Re^2: Correct syntax for using \copy to import a file into a Postgres db

thx,

i tried \\c but that also wasn't working.

your second idea was a good one. i printed $s2 and entered it directly into psql.

that, however, revealed another issue:

btest-> \copy (testingtable) FROM 'data.tsv'
data.tsv: No such file or directory
[download]

now i have to figure out what directory i'm in and what directory the file is in. according to some documentation, i should be able to get the first by entering in \!pwd, however, psql is telling me that is an invalid command.

Comment on Re^2: Correct syntax for using \copy to import a file into a Postgres db Download Code

Replies are listed 'Best First'.
Re^3: Correct syntax for using \copy to import a file into a Postgres db by Anonymous Monk on Sep 03, 2014 at 16:40 UTC
Hi did u fixed the error? If yes please suggest me with some hint. I'm facing the same error even when giving the correct file path	[reply]