Re: Normalising an existing table - how? - Mailing list pgsql-sql

From Graham Leggett
Subject Re: Normalising an existing table - how?
Date
Msg-id 40DB4B64.5080101@sharp.fm
Whole thread Raw
In response to Re: Normalising an existing table - how?  (Frank Bax <fbax@sympatico.ca>)
Responses Re: Normalising an existing table - how?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Frank Bax wrote:

> Do all three steps in one command:
> 
> create table newtable as (select key1, key2, money from oldtable);

How would I put the primary key of each row in newtable back into 
oldtable? Also, newtable already exists and contains data - I need to 
add normalised data to an already partially normalised database.

Regards,
Graham
--


pgsql-sql by date:

Previous
From: Graham Leggett
Date:
Subject: Re: Normalising an existing table - how?
Next
From: Geoffrey
Date:
Subject: Re: feature request ?