*To dump data or structure in the database from a dump file
$psql -u DBUserName datbaseName < databaseName_dump.sql
*To take the dump from the database
$pg_dump -u databaseName > filename.sql // data + structure
It will ask the username and password of database
$pg_dump -u databaseName -a > filename.sql // only data
$pg_dump -u databaseName -s > filename.sql // only structure
$pg_dump –username=sql-ledger -W databaseName > filename.sql
It will ask the password of database
The exact command should be:
$pg_dump –-username=sql-ledger -W databaseName > filename.sql
or
$pg_dump –U -W databaseName > filename.sql
Comment by Sanjay — February 22, 2008 @ 8:23 pm