Re: [GENERAL] syntax error while using pg_dump in Postgres 8.4

2014-10-30 Thread David G Johnston
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

Re: [GENERAL] syntax error while using pg_dump in Postgres 8.4

2014-10-30 Thread David G Johnston
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