Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IE6hE57383 for ; Mon, 18 Feb 2002 09:06:43 -0500 (EST) (envelope-from pgsql@symcom.com) Message-Id: <200202181406.g1IE6hE57383@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Mon, 18 Feb 2002 09:23:54 -0500 Date: Mon, 18 Feb 2002 09:23:54 -0500 From: "postgresql" To: suresh@mithi.com, pgsql-sql@postgresql.org Subject: Re: Need to change the size of a field X-Mailer: WorldClient Pro 2.2.1 In-Reply-To: X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200202/208 X-Sequence-Number: 6632 suresh This is pretty simple.... Just do a pg_dump of the of the database, edit the text file, and reimport the new definitions. something like dg_dump 'targetdb' > outputfile This is the same thing you are doing to backup your data. : ) Next open the outputfile in a text editor. Notice that you have all the create table directives. Edit the value in the definition area and save the file. drop the original database. then reimport the dump file (you will first have to createdb because you dropped it remember). That's it. Your pg_dump files are your friends. Ted -----Original Message----- From: To: Date: Mon, 18 Feb 2002 19:00:49 +0530 Subject: [SQL] Need to change the size of a field > Hi > > I have a table with one of the fields as a varchar(32) field. This > table has > about 100,000 records. > I want to increase the size of the varchar field to 64. How can this be > done > without affecting the data already present ? > Thanx in advance. > regards > suresh > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org