Jason Minion
From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Aniko.Badzong@xxxxxxxxxxxx
Sent: Thursday, March 02, 2006 8:17 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: [ADMIN] 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.
su - postgres -c "echo
"\""copy test from '/data/20060227.out';"\"" | psql imsdb"
this is how it looks like in Perl:
system ("su - postgres -c \"echo
\"\"\"copy test from \'/data/log/20060115.out\'\;\"\"\" | psql imsdb\"");
I escape always the " but then I get the
following error.
copy
sh: | psql imsdb: not found
If I try the other way around there is always
an error that role c does not exist....
system ("su - postgres -c \"psql imsdb -c \"copy mss6n from
'/data/20060227.out'\;\"");
psql:
warning: extra command-line argument "copy" ignored
psql: FATAL: role "-c" does not exist
If I try to use copy with the -c option I
always get an error that role -c does not exist.
Anyone has any idea why?
I was searching in the knowledge database and docs for
this error but I can not find anything.
Many thanks
Aniko
