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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
