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:
