Re: Moving Specific Data Across Schemas Including FKs
От | Raymond O'Donnell |
---|---|
Тема | Re: Moving Specific Data Across Schemas Including FKs |
Дата | |
Msg-id | 55393500.5020205@iol.ie обсуждение исходный текст |
Ответ на | Moving Specific Data Across Schemas Including FKs (Cory Tucker <cory.tucker@gmail.com>) |
Ответы |
Re: Moving Specific Data Across Schemas Including FKs
Re: Moving Specific Data Across Schemas Including FKs |
Список | pgsql-general |
On 23/04/2015 18:09, Cory Tucker wrote: > I have the need to move a specific set of data from one schema to > another. These schemas are on the same database instance and have all > of the same relations defined. The SQL to copy data from one table is > relatively straightforward: > > INSERT INTO schema_b.my_table > SELECT * FROM schema_a.my_table WHERE ... > > What I am trying to figure out is that if I also have other relations > that have foreign keys into the data I am moving, how would I also move > the data from those relations and maintain the FK integrity? I'd create the tables in the new schema without the FK constraints, copy the data, then add the constraints afterwards. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
В списке pgsql-general по дате отправления: