Postgres Pro
Downloads
Home   >   mailing lists

Re: Reordering columns in a table - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Reordering columns in a table
Date
Msg-id 20060106160734.GB8972@webserv.wug-glas.de
Whole thread Raw
In response to Reordering columns in a table  (John McCawley <nospam@hardgeus.com>)
List pgsql-general
Tree view 
am  06.01.2006, um  9:45:53 -0600 mailte John McCawley folgendes:
> Is there a way to change the order of columns in a table in Postgres after
> it has been created?  Back when I used MS SQL Server, it was trivial to go

Yes. 'select foo, bar, batz from table', 'select bar, foo, batz from
table' or 'select batz, bar, foo from table'.

Please, if you create a new thread, then make a new thread and do not
response to a other mail.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Arrays and Performance
Next
From: Jaime Casanova
Date:
Subject: Re: Adding another primary key to a populated table