From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: i have  table
Date: Tue, 3 Oct 2006 14:00:35 +0300
User-Agent: KMail/1.9.3
References: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200610031400.35354.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 =CE=A4=CF=81=CE=AF=CF=84=CE=B7 03 =CE=9F=CE=BA=CF=
=84=CF=8E=CE=B2=CF=81=CE=B9=CE=BF=CF=82 2006 13:47, =CE=BF/=CE=B7 Penchalai=
ah P. =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hi ...
>
> I have one table with 12 fields..
>
>
>
> CREATE TABLE addition_alteration_memo
>
> (
>
>   addition_alteration_memo int8 NOT NULL DEFAULT
> nextval('addition_alteration_memo_addition_alteration_memo_seq'::regclas
> s),
>
>   cda_no varchar(7) NOT NULL,
>
>   week numeric,
>
>   sheet_no numeric,
>
>   serial_no numeric,
>
>   date date,
>
>   dr_no varchar,
>
>   amount numeric,
>
>   memo_no varchar,
>
>   memo_date date,
>
>   no_instalments numeric,
>
>   instalment_rate numeric)
>
>
>
> now I want to add one more field in this table.. but that field has to
> come next to cda_no.. I mean as a 3rd field.. If I am adding that field
> it is coming last field ...
>
> may I know how it is possible to that table...
>

2 notes:
1) Why do you feel that this presentational reordering is important. Normal=
ly=20
it should not be important, otherwise some engineering flaw is hanging=20
around.
2) If you are sure it is important, one way to do this, is dump, change the=
=20
order of the field in the .sql and restore.

>
>
> Thanks  &  Regards
>
> Penchal reddy | Software Engineer
>
> Infinite Computer Solutions | Exciting Times...Infinite Possibilities...
>
>
> SEI-CMMI level 5 | ISO 9001:2000
>
> IT SERVICES | BPO
>
>
> Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities |
> Retail & Distribution | Government
>
>
> Tel +91-80-5193-0000(Ext:503)| Fax  +91-80-51930009 | Cell No
> +91-9980012376|www.infics.com
>
> Information transmitted by this e-mail is proprietary to Infinite
> Computer Solutions and/ or its Customers and is intended for use only by
> the individual or entity to which it is addressed, and may contain
> information that is privileged, confidential or exempt from disclosure
> under applicable law. If you are not the intended recipient or it
> appears that this mail has been forwarded to you without proper
> authority, you are notified that any use or dissemination of this
> information in any manner is strictly prohibited. In such cases, please
> notify us immediately at info.in@infics.com and delete this mail from
> your records.
>
>
>
>
>
> Information transmitted by this e-mail is proprietary to Infinite Computer
> Solutions and / or its Customers and is intended for use only by the
> individual or the entity to which it is addressed, and may contain
> information that is privileged, confidential or exempt from disclosure
> under applicable law. If you are not the intended recipient or it appears
> that this mail has been forwarded to you without proper authority, you are
> notified that any use or dissemination of this information in any manner =
is
> strictly prohibited. In such cases, please notify us immediately at
> info.in@infics.com and delete this email from your records.

=2D-=20
Achilleas Mantzios