Hi All,

I need to write a shell script that can be run by cron to automatically load
data into a PostgreSQL database. I have been experimenting with the copy
command in psql and I have a few questions.

How can I run a copy command from a script?
What is the usage for the copy command when getting data from stdin?

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Keith Worthington wrote:

0 22 * * * /usr/local/pgsql/bin/pgsql -p
5432 -d imperial -c" COPY dataTable FROM 'fileName' WITH NULL AS '';"
or place the script inside of a file and have cron call it using
something like:
0 22 * * * sh
/usr/local/pgsql/myShellScript.sh

Ron



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org