On 12/16/2014 07:29 AM, Ramesh T wrote:
hi,
i need to export a file the database
postgres
pg_dump -U postgres -C -Fp -f c:/backup/db2.dump db_1;
where i can run pg_dump
please send me details
i want to export db_1 to db2
i got an error below
postgres=# pg_dump -U postgres -C -Fp -f c:/backup/db_2.dump
db_1;
ERROR: syntax error at or near "pg_dump"
LINE 1: pg_dump -U postgres -C -Fp -f c:/backup/db_2du...
Are you trying this from inside psql?
If so pg_dump is a command line program and needs to be from the shell
terminal not inside psql.
i'm using putty to connect host
how to bash to c:\..?
That would depend on where your Postgres server is relative to the c:\
drive.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
