From ghanshyam@newgen.co.in Fri Apr 1 07:31:04 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 434DC53A11 for ; Fri, 1 Apr 2005 08:31:04 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09179-06 for ; Fri, 1 Apr 2005 07:31:02 +0000 (GMT) Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by svr1.postgresql.org (Postfix) with SMTP id 0596E53A42 for ; Fri, 1 Apr 2005 08:30:59 +0100 (BST) Received: (qmail 1177 invoked by uid 504); 1 Apr 2005 07:35:45 -0000 Received: from ghanshyam@newgen.co.in by mx.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:0(202.140.41.205):. Processed in 2.304615 secs); 01 Apr 2005 07:35:45 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 1 Apr 2005 07:35:43 -0000 Received: (qmail 1355 invoked by uid 504); 1 Apr 2005 07:35:20 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.575775 secs); 01 Apr 2005 07:35:20 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 1 Apr 2005 07:35:17 -0000 Message-ID: <00a301c53689$86d2ab60$be05a8c0@ng3024> From: "sharma;G.S." To: Subject: Can WE modify column of a table in postgres 7.3 Date: Fri, 1 Apr 2005 12:37:51 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A0_01C536B7.9E434150" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.884 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_20_30, HTML_MESSAGE, HTML_TEXT_AFTER_BODY, HTML_TEXT_AFTER_HTML, RCVD_BY_IP X-Spam-Level: * X-Archive-Number: 200504/8 X-Sequence-Number: 17021 This is a multi-part message in MIME format. ------=_NextPart_000_00A0_01C536B7.9E434150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I want to=20 rename and modify the data type of a column in postgres 7.3 can any body = help me ...that it is possible to do the above in postgres and if yes = pls provide me the syntax thanx in advance ------=_NextPart_000_00A0_01C536B7.9E434150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I want to
rename and modify the data type of a = column in=20 postgres 7.3 can any body help me ...that it is possible to do the above = in=20 postgres and if yes pls provide me the syntax
thanx in = advance
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_00A0_01C536B7.9E434150-- From mike@fuhr.org Sat Apr 2 01:06:01 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 72A645381B for ; Sat, 2 Apr 2005 02:06:01 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16362-01 for ; Sat, 2 Apr 2005 01:05:54 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id C02835384D for ; Sat, 2 Apr 2005 02:05:50 +0100 (BST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j3215h7Q005875 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 1 Apr 2005 18:05:46 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j3215hrt009014; Fri, 1 Apr 2005 18:05:43 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j3215g1s009013; Fri, 1 Apr 2005 18:05:42 -0700 (MST) (envelope-from mfuhr) Date: Fri, 1 Apr 2005 18:05:42 -0700 From: Michael Fuhr To: "sharma;G.S." Cc: pgsql-admin@postgresql.org Subject: Re: Can WE modify column of a table in postgres 7.3 Message-ID: <20050402010542.GA8963@winnie.fuhr.org> References: <00a301c53689$86d2ab60$be05a8c0@ng3024> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00a301c53689$86d2ab60$be05a8c0@ng3024> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/30 X-Sequence-Number: 17043 On Fri, Apr 01, 2005 at 12:37:51PM +0530, sharma;G.S. wrote: > > I want to rename and modify the data type of a column in postgres 7.3 > can any body help me ...that it is possible to do the above in postgres > and if yes pls provide me the syntax You can rename columns with ALTER TABLE: http://www.postgresql.org/docs/7.3/interactive/sql-altertable.html In 8.0 and later you can use ALTER TABLE to change a column's type; see the FAQ for how to do it in older versions: http://www.postgresql.org/docs/faqs.FAQ.html#4.3 -- Michael Fuhr http://www.fuhr.org/~mfuhr/