Re: Field's position in Table

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Field's position in Table
Date: 2009-08-20 09:12:23
Message-ID: 4A8D1377.5060702@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kalai R wrote:
> Hi ,
>
> I have a problem in Postgres.
>
> When adding a new field in the existing table, i want to add the filed
> in a particular position. Is there any way to change the fields
> position in the table. Any Solution to this problem would be
> much appreciated.

don't use * in SELECT statements, and its not a problem.

SQL relations should have neither field order nor row order unless such
is explicitly given

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scara Maccai 2009-08-20 09:21:25 R: Field's position in Table
Previous Message Jorge Daine Quiambao 2009-08-20 09:08:17 ERROR: could not access file "$libdir/xxid": No such file or directory