KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel