Re: Normalising an existing table - how?

From: Graham Leggett <minfrin(at)sharp(dot)fm>
To: Frank Bax <fbax(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Normalising an existing table - how?
Date: 2004-06-24 21:45:08
Message-ID: 40DB4B64.5080101@sharp.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
--

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Geoffrey 2004-06-24 22:43:12 Re: feature request ?
Previous Message Graham Leggett 2004-06-24 21:42:40 Re: Normalising an existing table - how?