From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | "Erik Jones" <erik(at)myemma(dot)com> |
Cc: | "Markus Schaber" <schabi(at)logix-tt(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: i have table |
Date: | 2006-10-04 14:54:28 |
Message-ID: | bf05e51c0610040754o101408c2y8a743697b9ceee4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 10/4/06, Erik Jones <erik(at)myemma(dot)com> wrote:
>
> There is one non-SQL related reason that I like to be able to order
> columns, at least the way they are displayed whenever the table is
> described: human comprehension. For example, I like to group all keys
> in a table before data, that includes primary as well as foreign keys.
> So, say I'm building on to an existing application and I need to do an
> ALTER TABLE on an existing table to add a foreign key to an existing
> table. I'd like that key to be listed with the other keys, but
> presently that's not possible in a simple way and, to be honest, I
> usually just go without as the process you've described below is too
> prone to user (human) error when dealing with live, sensitive data for
> me to want to mess with it.
Ah, but it is possible... if you use views.
I recommend you build views and query off them. Then you can control the
order the columns will appear.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron Bono | 2006-10-04 14:55:49 | Re: [SQL] How to overwrite a table [only data]? |
Previous Message | Erik Jones | 2006-10-04 14:23:30 | Re: i have table |