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