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