From jaruwan@gits.net.th Tue Jan 30 03:17:30 2001 Received: from edison.gits.net.th (edison.gits.net.th [164.115.2.130]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0U3HUq59461; Mon, 29 Jan 2001 22:17:30 -0500 (EST) (envelope-from jaruwan@gits.net.th) Received: from wan ([203.150.154.109]) by edison.gits.net.th (8.10.1/8.10.1) with SMTP id f0U3HYl27535; Tue, 30 Jan 2001 10:17:34 +0700 (GMT) Message-ID: <015601c08a6b$dd92e7e0$6d9a96cb@ntl> From: "Jaruwan Laongmal" To: , Subject: How to modify type in table? Date: Tue, 30 Jan 2001 10:22:23 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0153_01C08AA6.88DD90C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200101/1328 X-Sequence-Number: 4093 This is a multi-part message in MIME format. ------=_NextPart_000_0153_01C08AA6.88DD90C0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Dear Sir. Would you like to inform me how to modify type in table? For example , I define type as varchar(14) , but I want to modify to varcha= r(120). How to do this. Thank you so much Jaruwan ------=_NextPart_000_0153_01C08AA6.88DD90C0 Content-Type: text/html; charset="windows-874" Content-Transfer-Encoding: quoted-printable
Dear Sir.
Would you like to inform me how to modify= type=20 in table?
For example , I define type as varchar(14= ) , but=20 I want to modify to varchar(120). How to do this.
 
Thank you so much
Jaruwan
------=_NextPart_000_0153_01C08AA6.88DD90C0-- From manny@msuiit.edu.ph Mon Feb 5 17:48:00 2001 Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f15Hm0x40765 for ; Mon, 5 Feb 2001 12:48:00 -0500 (EST) (envelope-from pgsql-hackers-owner@postgresql.org) Received: from tinago.msuiit.edu.ph (tinago.msuiit.edu.ph [202.78.82.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0U3gtq61411; Mon, 29 Jan 2001 22:42:57 -0500 (EST) (envelope-from manny@msuiit.edu.ph) Received: from localhost (manny@localhost) by tinago.msuiit.edu.ph (8.9.3/8.9.3) with ESMTP id LAA30902; Tue, 30 Jan 2001 11:49:41 +0800 X-Authentication-Warning: tinago.msuiit.edu.ph: manny owned process doing -bs Date: Tue, 30 Jan 2001 11:49:41 +0800 (PHT) From: Manuel Cabido To: Jaruwan Laongmal cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: How to modify type in table? In-Reply-To: <015601c08a6b$dd92e7e0$6d9a96cb@ntl> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/99 X-Sequence-Number: 4220 Hi there, I am compiling postgresql 7.1beta4. How would i change the 8k row limit? -- Manny C. Cabido ==================================== e-mail:manny@tinago.msuiit.edu.ph manny@sun.msuiit.edu.ph ===================================== From olly@lfix.co.uk Tue Jan 30 12:22:13 2001 Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0UCMDq11513 for ; Tue, 30 Jan 2001 07:22:13 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 14NZnS-0005a3-0V; Tue, 30 Jan 2001 12:22:06 +0000 Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.11.2/8.11.2/Debian 8.11.2-1) with ESMTP id f0UCM5F17760; Tue, 30 Jan 2001 12:22:05 GMT Message-Id: <200101301222.f0UCM5F17760@linda.lfix.co.uk> X-Mailer: exmh version 2.2 06/23/2000 (debian 2.2-1) with nmh-1.0.4+dev X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: pgsql-sql@postgresql.org Subject: Re: [HACKERS] How to modify type in table? In-reply-to: Message from "Jaruwan Laongmal" of Tue, 30 Jan 2001 10:22:23 +0700. <015601c08a6b$dd92e7e0$6d9a96cb@ntl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 30 Jan 2001 12:22:05 +0000 From: "Oliver Elphick" X-Archive-Number: 200101/453 X-Sequence-Number: 1129 "Jaruwan Laongmal" wrote: >Would you like to inform me how to modify type in table? >For example , I define type as varchar(14) , but I want to modify to varcha= >r(120). How to do this. There is no facility to do this directly. (Allowing columns to change their type would possibly involve rewriting the entire table.) You can use pg_dump to dump either a database or a particular table. Then you can edit the CREATE TABLE command in the dump output and then create a new database or table from the dump. If the table in question is not referenced by any other objects, dump it (pg_dump -t table database >dump); edit the dump; delete or rename the old table; and finally restore the dump (psql -d database ; Mon, 5 Feb 2001 16:00:16 -0500 (EST) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 1973 invoked by uid 500); 5 Feb 2001 17:39:19 -0000 From: "Albert REINER" Date: Mon, 5 Feb 2001 18:39:19 +0100 To: pgsql-sql@postgresql.org Subject: Re: How to modify type in table? Message-ID: <20010205183919.B1866@frithjof> Mail-Followup-To: pgsql-sql@postgresql.org References: <015601c08a6b$dd92e7e0$6d9a96cb@ntl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <015601c08a6b$dd92e7e0$6d9a96cb@ntl>; from jaruwan@gits.net.th on Tue, Jan 30, 2001 at 10:22:23AM +0700 X-Archive-Number: 200102/60 X-Sequence-Number: 1230 Saluton, On Tue, Jan 30, 2001 at 10:22:23AM +0700, Jaruwan Laongmal wrote: > Dear Sir. > Would you like to inform me how to modify type in table? > For example , I define type as varchar(14) , but I want to modify to varchar(120). How to do this. If it is not too much data, the easiest would be to use pg_dump to dump the database (or just the table), edit the definition, and feed the changed file to psql in order to get the data back. Or you can create a different table with the correct structure, copy the data there, drop the old table, rename the new one to the correct one. Albert. -- -------------------------------------------------------------------------- Albert Reiner Deutsch * English * Esperanto * Latine -------------------------------------------------------------------------- From lockhart@alumni.caltech.edu Tue Feb 6 04:42:34 2001 Received: from golem.fourpalms.org (www.fourpalms.org [64.3.68.148]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f164gYx09533; Mon, 5 Feb 2001 23:42:34 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1]) by golem.fourpalms.org (Postfix) with ESMTP id 39DF6FEC2; Tue, 6 Feb 2001 04:48:47 +0000 (UTC) Message-ID: <3A7F822F.23F77A7@alumni.caltech.edu> Date: Tue, 06 Feb 2001 04:48:47 +0000 From: Thomas Lockhart Reply-To: lockhart@fourpalms.org Organization: Yes X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17-21mdksmp i686) X-Accept-Language: en MIME-Version: 1.0 To: Manuel Cabido Cc: Jaruwan Laongmal , pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org Subject: Re: How to modify type in table? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/148 X-Sequence-Number: 4280 > I am compiling postgresql 7.1beta4. How would i change the 8k row > limit? There is no 8k row limit anymore. But if there were, you would modify a #define in the source code and recompile (check the docs for more details). - Thomas