Обсуждение: 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

Not the real solution for your problem, but if you are already using perl, then why not give a try to Pg?

http://search.cpan.org/search?query=Pg&mode=all

Regards,
G.-




--
/"\   ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
X  - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------

Jason Minion

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

Jason Minion

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