| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Łukasz Jarych <jaryszek(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Copies or tables in schema or copiyng of database - database versioning |
| Date: | 2018-06-22 12:57:22 |
| Message-ID: | 2dc9808b-78d7-a47c-c80e-b42919633295@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Jelinek | 2018-06-22 13:16:31 | Re: Can PostgreSQL create new WAL files instead of reusing old ones? |
| Previous Message | DiasCosta | 2018-06-22 12:17:20 | Re: SQL Query never ending... |