Skip site navigation (1) Skip section navigation (2)

Re: change existing table definition

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: chen(at)musc(dot)edu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: change existing table definition
Date: 2005-06-28 14:14:25
Message-ID: 200506281614.25981.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Chuming Chen wrote:
> How can I change the column definition of an existing table, ie. from
> varchar(30) to varchar(50)? Is there any way to add a new column to
> an existing table?

The ALTER TABLE command can do all that.  You need version 8.0 or later 
for some functionality though.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

pgsql-admin by date

Next:From: Johannes LochmannDate: 2005-06-28 14:26:19
Subject: Re: change existing table definition
Previous:From: Ian FREISLICHDate: 2005-06-28 13:32:14
Subject: Re: How to compare the schemas ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group