On 4/23/15 1:08 PM, Raymond O'Donnell wrote:
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 withou
On 23/04/2015 19:08, Raymond O'Donnell wrote:
> 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 tab
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 INT
On Thu, Apr 23, 2015 at 10:27 AM Steve Atkins wrote:
>
> On Apr 23, 2015, at 10:09 AM, 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
On Apr 23, 2015, at 10:09 AM, 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:
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 W
