Postgres COPY FROM csv file- No such file or directory

postgresql csv import psql tsv
nerdenator picture nerdenator · May 17, 2013 · Viewed 30k times · Source

I'm trying to import a (rather large) .txt file into a table geonames in PostgreSQL 9.1. I'm in the /~ directory of my server, with a file named US.txt placed in that directory. I set the search_path variable to geochat, the name of the database I'm working in. I then enter this query:

COPY geonames
FROM 'US.txt',
DELIMITER E'\t',
NULL 'NULL');

I then receive this error:

ERROR: could not open file "US.txt" for reading: No such file or directory.

Do I have to type in \i US.txt or something similar first, or should it just get it from the present working directory?

Answer

jvdw picture jvdw · Nov 10, 2014

Maybe a bit late, but hopefully useful:

Use \copy instead

https://wiki.postgresql.org/wiki/COPY

jvdw

Related questions

Importing CSV file PostgreSQL using pgAdmin 4

I'm trying to import a CSV file to my PostgreSQL but I get this error ERROR: invalid input syntax for integer: "id;date;time;latitude;longitude" CONTEXT: COPY test, line 1, column id: "id;date;time;latitude;longitude" my csv file …

Read More
How to import CSV file data into a PostgreSQL table?

How can I write a stored procedure that imports data from a CSV file and populates the table?

Read More
Save PL/pgSQL output from PostgreSQL to a CSV file

What is the easiest way to save PL/pgSQL output from a PostgreSQL database to a CSV file? I'm using PostgreSQL 8.4 with pgAdmin III and PSQL plugin where I run queries from.

Read More