Title: psql copy script
Hi Alvaro
Thanks for the help but it does not work.
when I execute it than I get:
[test/data] su - postgres -c "psql logdb -c 'copy test from \'/data/log/bla\''"
Unmatched '.
If I correct the error than I get the following:
[test/data] su - postgres -c "psql
Hi
I have tried it yesterday to escaoe the double qutoes and I get the error:
[test] su - postgres -c "echo \"copy test from '/data/log/bla';"\" | psql logdb"
Unmatched ".
somehow does not want to work.
RE: [SQL] psql in the command line
from: Russell Simpkins [EMAIL PROTECTED]
Title: FW: copy command
Hi
I have tried it yesterday to escaoe the double qutoes and I get the error:
[test] su - postgres -c "echo \"copy test from '/data/log/bla';"\" | psql logdb"
Unmatched ".
somehow does not want to work.
RE: [SQL] psql in the command line
from: Russell S
Title: sql copy does not work
Hi
I have a problem with the copy command. I need to write a Perl script where I copy the log files into the database.
If I use the copy following syntax in shell script it works, but I need to use it in Perl.
In shell script look like this and it works.
s
Title: sql copy does not work
Hi Jason
You are a genius:-)) It worked
I am fighting with it since a
week...
Thank you so much.
Regards
Aniko
From: Jason Minion
[mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 3:49
PMTo: Badzong Aniko, FX-IT-SDY-CIA-MSG;
pgsql-admin@postgres