pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: postgresql <pgsql@symcom.com>
To: suresh@mithi.com
To: pgsql-sql@postgresql.org
Subject: Re: Need to change the size of a field
Date: Mon, 18 Feb 2002 09:23:54 -0500
Message-ID: <200202181406.g1IE6hE57383@postgresql.org> (raw)
In-Reply-To: <NFBBKGHMBKLDMDLMGGHBEENCCNAA.suresh@mithi.com>

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: <suresh@mithi.com>
To: <pgsql-sql@postgresql.org>
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





view thread (4+ messages)  latest in thread

Message-ID: <200202181406.g1IE6hE57383@postgresql.org>
Permalink:  ../200202181406.g1IE6hE57383@postgresql.org/
Also on:    postgresql.org/message-id/200202181406.g1IE6hE57383@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pgsql@symcom.com, suresh@mithi.com
  Subject: Re: Need to change the size of a field
  In-Reply-To: <200202181406.g1IE6hE57383@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox