[ADMIN] psql copy script

2006-01-25 Thread Aniko.Badzong
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

[ADMIN]

2006-01-26 Thread Aniko.Badzong
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]

[ADMIN] FW: copy command

2006-01-26 Thread Aniko.Badzong
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

[ADMIN] sql copy does not work

2006-03-02 Thread Aniko.Badzong
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

Re: [ADMIN] sql copy does not work

2006-03-02 Thread Aniko.Badzong
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