Horton
Menu

Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)

Bruno Wolff III <bruno@wolff.to>

View thread
From: Bruno Wolff III <bruno@wolff.to>
To: Antti Haapala <antti.haapala@iki.fi>
Cc: Gavin Sherry <swm@linuxworld.com.au>, Hannu Krosing <hannu@tm.ee>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-10-12T15:45:13Z
Lists: pgsql-hackers, pgsql-general 
On Sat, Oct 12, 2002 at 12:43:37 +0300,
  Antti Haapala <antti.haapala@iki.fi> wrote:
> 
> > I cannot think of any reason why changing column order should be
> > implemented in Postgres. Seems like a waste of time/more code bloat for
> > something which is strictly asthetic.
> 
> What about copy? AFAIK, copy doesn't allow column names being specified,
> so it's not purely aesthetic...

The SQL COPY command does (at least in 7.3). The \copy psql command
doesn't seem to allow this though.