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

Re: Preserving column order when recreating table.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Preserving column order when recreating table.
Date: 2004-09-15 14:22:01
Message-ID: 20040915162201.13be5102@svb.ucs.co.za (view raw or flat)
Thread:
Lists: pgsql-sql
Andrew Sullivan mentioned :
=> I'm not sure why you want to do the former, but in any case, it's
Because lazy people write inserts without specifying column names.

=> possible by creating a new table which has things the way you want;
=> select all the old data from the old table into the new table (using
=> the column names to get everything in the order you like, of course),

I like this idea, but each database may have a different table definition
for the same table, and if I want to automate this, I need to figure out the 
column names on the fly.

=> and then rename the old table, rename the new table to the old table
=> name, and drop the old table if you like.

I think I've got the solution now. I'll do it in two steps. 
Fist add/drop all the columns that are not there/not supposed to be there,
and in the second step do what you suggested.

Thanks!!

Kind Regards
Stefan

In response to

Responses

pgsql-sql by date

Next:From: Andrew SullivanDate: 2004-09-15 14:42:12
Subject: Re: Preserving column order when recreating table.
Previous:From: Andrew SullivanDate: 2004-09-15 13:19:30
Subject: Re: Preserving column order when recreating table.

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