Sql – PostgreSQL how to create a copy of a database or schema

databasepostgresqlsql

Is there a simple way to create a copy of a database or schema in PostgreSQL 8.1?

I'm testing some software which does a lot of updates to a particular schema within a database, and I'd like to make a copy of it so I can run some comparisons against the original.

Best Solution

If it's on the same server, you just use the CREATE DATABASE command with the TEMPLATE parameter. For example:

CREATE DATABASE newdb WITH TEMPLATE olddb;

Related Solutions

PostgreSQL “DESCRIBE TABLE”

Try this (in the psql command-line tool):

\d+ tablename

See the manual for more info.

PostgreSQL: Show tables in PostgreSQL

From the psql command line interface,

First, choose your database

\c database_name

Then, this shows all tables in the current schema:

\dt

Programmatically (or from the psql interface too, of course):

SELECT * FROM pg_catalog.pg_tables;

The system tables live in the pg_catalog database.

Best Solution

Related Solutions

PostgreSQL “DESCRIBE TABLE”

PostgreSQL: Show tables in PostgreSQL

Related Question