N
N
NDll2021-09-15 16:19:53
Vagrant
NDll, 2021-09-15 16:19:53

Why does it say file not found when importing?

I use Homestead Laravel + PostgreSql

when importing

I go

vgrant ssh
psql -U homestead -h localhost
\c mysdb

and fulfill

\copy `mp_geo_networks`(network, geoname_id, registered_country_geoname_id, represented_country_geoname_id,is_anonymous_proxy, is_satellite_provider, postal_code, latitude, longitude, accuracy_radius) from 'C:\Users\maksi\Downloads\GeoIP2-City-Europe-CSV_20210914\GeoIP2-City-Europe-CSV_20210914\GeoIP2-City-Europe-Blocks-IPv4.csv' with (format csv, header);

writes
No such file or directory

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Volodin, 2021-09-15
@NDll

Because the path is wrong
The path should be relative not to your computer but to the vagrant virtual machine

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question