Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id B7A4D9FB882
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Mar 2007 10:35:52 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 84744-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Mar 2007 10:35:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from smtpout21.attiva.biz (smtpout21.attiva.biz [85.37.16.23])
	by postgresql.org (Postfix) with ESMTP id D7FF79FB7AE
	for <pgsql-sql@postgresql.org>; Thu, 15 Mar 2007 10:35:44 -0300 (ADT)
Received: from fbcmfe02b10.fbc.local ([192.168.30.91]) by smtpout21.attiva.biz
	with Microsoft SMTPSVC(6.0.3790.1830);
	Thu, 15 Mar 2007 14:35:42 +0100
Received: from dream ([88.34.161.130]) by fbcmfe02b10.fbc.local with Microsoft
	SMTPSVC(6.0.3790.1830); Thu, 15 Mar 2007 14:35:41 +0100
Message-ID: <00de01c76706$d37d56e0$1102a8c0@dream>
Reply-To: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
From: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
To: <pgsql-sql@postgresql.org>
Subject: Alter Table
Date: Thu, 15 Mar 2007 14:35:41 +0100
Organization: Studio FORM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00DB_01C7670F.34DDA5E0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-OriginalArrivalTime: 15 Mar 2007 13:35:41.0813 (UTC)
	FILETIME=[D36FC250:01C76706]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.219 tagged_above=0 required=5 tests=AWL, BAYES_50,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200703/209
X-Sequence-Number: 27847

This is a multi-part message in MIME format.

------=_NextPart_000_00DB_01C7670F.34DDA5E0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

When i alter a table and add a new column it always adds it to the end =
of the table. Is there any way to tell it to add the new column at the =
5th position or to add the new column after a surtain column.

Thanks

Shavonne Wijesinghe
http://www.studioform.it


------=_NextPart_000_00DB_01C7670F.34DDA5E0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>When i alter a table and add a new =
column it always=20
adds it to the end of the table. Is there any way to tell it to add the =
new=20
column at the 5th position or to add the new column after a surtain=20
column.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Shavonne Wijesinghe<BR><A=20
href=3D"http://www.studioform.it">http://www.studioform.it</A></FONT></DI=
V>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00DB_01C7670F.34DDA5E0--