01 May 2005

pg_dump Postgresql.

[in office]Annoying pg_dump and restore database problem. I had a sequence issue_id_seq in a database. But after dump the database and restore to new database, the sequence become issue_issue_id_seq. Until now this problem don't solve. Grrrr...

[at home] How to copy schema of a database to new database?

createdb new_db
pg_dump -s old_db | psql new_db

No comments: