Re: syntax error while using pg_dump in Postgres 8.4

CrabbeS wrote
> I am trying to copy a table form one database to another by using this
> command in the SQL-query builder:
> pg_dump TA2000 -t from Forest -c -s | psql -h localhost postgis;

pg_dump is a standalone application (i.e., something you run in a
shell/command-line) and not an SQL command.

Pipes (the "|" in your string) are also shell/command-line only and cannot
be used where SQL is expected.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/syntax-error-while-using-pg-dump-in-Postgres-8-4-tp5825054p5825056.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.