Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 88B149FB3F0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  4 Oct 2006 11:54:43 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 58359-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed,  4 Oct 2006 11:54:31 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.179])
	by postgresql.org (Postfix) with ESMTP id AD03C9FB373
	for <pgsql-sql@postgresql.org>; Wed,  4 Oct 2006 11:54:30 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id d80so299203pyd
	for <pgsql-sql@postgresql.org>; Wed, 04 Oct 2006 07:54:29 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=gFaC7HufpikXArAJxf017494aewZNL6unqe1vFVR9BYECuFbtj6/oCAyRoAyiNZBU3duW16022lLlqjzmc0fQLO02bS9MNjoYSccdv0FuSsFrZHVNvbyASWJcYdxs+auMwTK5gCOTc25i6ohCMTzMPK7DUjM3MXNAwfy7fO+ySM=
Received: by 10.35.99.17 with SMTP id b17mr1374090pym;
	Wed, 04 Oct 2006 07:54:28 -0700 (PDT)
Received: by 10.35.78.6 with HTTP; Wed, 4 Oct 2006 07:54:28 -0700 (PDT)
Message-ID: <bf05e51c0610040754o101408c2y8a743697b9ceee4@mail.gmail.com>
Date: Wed, 4 Oct 2006 09:54:28 -0500
From: "Aaron Bono" <postgresql@aranya.com>
To: "Erik Jones" <erik@myemma.com>
Subject: Re: i have table
Cc: "Markus Schaber" <schabi@logix-tt.com>, pgsql-sql@postgresql.org
In-Reply-To: <4523C3E2.4010300@myemma.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_13547_29053048.1159973668572"
References: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
	<45237D6E.1030601@logix-tt.com> <4523C3E2.4010300@myemma.com>
X-Google-Sender-Auth: 3cee0679fe3dac61
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.512 tagged_above=0 required=5 tests=AWL, HTML_30_40,
	HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200610/39
X-Sequence-Number: 26428

------=_Part_13547_29053048.1159973668572
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 10/4/06, Erik Jones <erik@myemma.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
==================================================================

------=_Part_13547_29053048.1159973668572
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 10/4/06, <b class="gmail_sendername">Erik Jones</b> &lt;<a href="mailto:erik@myemma.com">erik@myemma.com</a>&gt; wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
There is one non-SQL related reason that I like to be able to order<br>columns, at least the way they are displayed whenever the table is<br>described:&nbsp;&nbsp;human comprehension.&nbsp;&nbsp;For example, I like to group all keys<br>in a table before data, that includes primary as well as foreign keys.
<br>So, say I'm building on to an existing application and I need to do an<br>ALTER TABLE on an existing table to add a foreign key to an existing<br>table.&nbsp;&nbsp;I'd like that key to be listed with the other keys, but<br>presently that's not possible in a simple way and, to be honest, I
<br>usually just go without as the process you've described below is too<br>prone to user (human) error when dealing with live, sensitive data for<br>me to want to mess with it.</blockquote><div><br>Ah, but it is possible... if you use views.
<br><br>I recommend you build views and query off them.&nbsp; Then you can control the order the columns will appear.<br></div><br></div>==================================================================<br>&nbsp;&nbsp; Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.
<br>&nbsp;&nbsp; <a href="http://www.aranya.com">http://www.aranya.com</a><br>&nbsp;&nbsp; <a href="http://codeelixir.com">http://codeelixir.com</a><br>==================================================================

------=_Part_13547_29053048.1159973668572--