pg_dump

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Hubert Lubaczewski <depesz(at)gmail(dot)com>
Subject: pg_dump
Date: 2014-12-16 15:29:33
Message-ID: CAK8Zd=vRia3kosKuAW-Dvt=-oh1uQZotWDUa0AwD9SahiVvaqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

i'm using putty to connect host
how to bash to c:\..?

Responses

  • Re: pg_dump at 2014-12-16 15:41:20 from Adrian Klaver

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-12-16 15:30:16 Re: Full text search prefix matching
Previous Message Vincent Veyron 2014-12-16 15:09:27 Re: Full text search prefix matching