| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reordering columns in a table |
| Date: | 2006-01-06 16:07:35 |
| Message-ID: | 20060106160734.GB8972@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-06 16:30:28 | Re: BUG #2148: Crashes on simple statement |
| Previous Message | Berend Tober | 2006-01-06 16:00:30 | Re: Reordering columns in a table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2006-01-06 16:13:18 | Re: Adding another primary key to a populated table |
| Previous Message | Joe Conway | 2006-01-06 16:04:13 | Re: Arrays and Performance |