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


The stupid question is the question not asked
	PerlMonks

by bichonfrise74 (Vicar)

on Nov 12, 2009 at 05:02 UTC ( [id://806644]=note: print w/replies, xml )

Need Help??

I'm not familiar with the syntax of Postgresql, but I think you just need to do something like this.

my $s2 = "\\copy (" ....
[download]

Or what you can do is to print $s2 and see if the syntax is valid in Postgresql.

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

Replies are listed 'Best First'.
Re^2: Correct syntax for using \copy to import a file into a Postgres db by BruceDB (Novice) on Nov 12, 2009 at 06:20 UTC
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.	[reply] [d/l]
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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://806644]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (6)

As of 2024-04-19 06:03 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found