Copies or tables in schema or copiyng of database - database versioning

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Copies or tables in schema or copiyng of database - database versioning
Date: 2018-06-22 08:12:48
Message-ID: CAGv31oeh_7CaJ_mkfNnZET_WAaw6RjsRCCQFVgcdeSgu=2Ftng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moreno Andreo 2018-06-22 08:46:01 Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data
Previous Message Michael Paquier 2018-06-22 06:37:26 Re: using pg_basebackup for point in time recovery