| From: | <Aniko(dot)Badzong(at)swisscom(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | psql in the command line |
| Date: | 2006-01-25 15:57:22 |
| Message-ID: | E502FDA6FE0C5A4BB4EFA4250A1E049001DBE047@sxmbx51.corproot.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
COPY
But when I try to execute it as root user I get the following error:
[est/data/log] su - postgres -c "echo 'copy test from /data/log/bla;'|
psql logdb"
ERROR: syntax error at or near "/" at character 16
LINE 1: copy test from /data/log/bla;
I have already tried with all kind of double and single quotes but it
does not work.
Anybody has an idea how can I make it run?
Thanks and regards
Aniko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-01-25 16:05:37 | Re: psql in the command line |
| Previous Message | Markus Schaber | 2006-01-25 14:54:42 | Re: Changing the transaction isolation level within the stored |