[SQL] FW: sql copy does not work

Title: FW: 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 work

[SQL] psql in the command line

Title: psql in the command line Hi I need some help regarding psql syntax. I would like to copy text files into the database from the command line in a script. I have found already how can I do it as user postrgres: test:/opt/pgsql# echo "copy test from '/data/log/bla';" | psql logdb C