Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to copy entire database to new database?
What you guys handed me may be useful, but it appears to be completely useless. I drop the new database, create the new database under psql. Then, using pg_restore, I restore the database which was created using a from a pg_dump command. The create database command is (from psql) create...- joevol
- Post #4
- Forum: PostgreSQL Inc.: PostgreSQL
-
how to copy entire database to new database?
I wish to replicate an entire schema - all tables, keys, indexes, sequences, views, functions, and data. I will need to to do this eventually through a script, so that I can reset a schema, on demand, to a starting point. (We are using this schema for a product demonstration, and need the...- joevol
- Thread
- Replies: 4
- Forum: PostgreSQL Inc.: PostgreSQL
