Postgres Pro
Downloads
Home   >   mailing lists

Copies or tables in schema or copiyng of database - database versioning - Mailing list pgsql-general

From Łukasz Jarych
Subject Copies or tables in schema or copiyng of database - database versioning
Date
Msg-id CAGv31oeh_7CaJ_mkfNnZET_WAaw6RjsRCCQFVgcdeSgu=2Ftng@mail.gmail.com
Whole thread Raw
Responses Re: Copies or tables in schema or copiyng of database - databaseversioning  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi Guys,

I want to create copies of tables in postgresql to use them by each user in coherent way, 

So version 1 will be schema1, version 2 will be schema2 (with copies of tables from version 1). 

How to perfom it ? 
Using pg dump and creating new schemas (or databases is a better idea)? 

Or it is a way to write sql to create new schema and copying the older one?

Best,
Jacek 

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: using pg_basebackup for point in time recovery
Next
From: Moreno Andreo
Date:
Subject: Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data