Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group