Re: sql copy does not work

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.-

On 3/2/06, Aniko(dot)Badzong(at)swisscom(dot)com <Aniko(dot)Badzong(at)swisscom(dot)com> wrote:
>
> 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
>

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