The psql console still operates mainly at the SQL level of input. You need
to use your OS's shell to run pg_dump.
Both psql and pg_dump are the same kind of application and are run in a
similar fashion.
David J.
On Thu, Oct 30, 2014 at 11:13 AM, CrabbeS [via PostgreSQL] <
ml-node+s1045698n5825
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