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

On 06/22/2018 01:12 AM, Łukasz Jarych wrote:

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?

I am trying to understand what you want:

1) The tables will be exactly the same in each schema or will they differ?

2) Is a user going to be restricted to a particular schema?

3) What is the purpose of this layout?

Best,
Jacek

--
Adrian Klaver
adrian.klaver@aklaver.com