sql copy does not work

From: <Aniko(dot)Badzong(at)swisscom(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: sql copy does not work
Date: 2006-03-02 14:17:14
Message-ID: E502FDA6FE0C5A4BB4EFA4250A1E049001DBE0B2@sxmbx51.corproot.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2006-03-02 14:43:25 Re: sql copy does not work
Previous Message Tom Lane 2006-03-01 23:01:01 Re: Need reference doc on precedence/ordering for pg_hba.conf