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

Re: character type modification

From: Michael Fuhr <mfuhr+pgsql-admin(at)fuhr(dot)org>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: character type modification
Date: 2003-12-16 17:35:46
Message-ID: 20031216173546.GA13018@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Dec 16, 2003 at 12:32:05PM -0500, Jodi Kanter wrote:

> Can I alter a column from character varying(128) to text without having 
> to create a temp table? I am running 7.3.3.

The FAQ has a question entitled "How do you remove a column from a
table, or change its data type?":

http://www.postgresql.org/docs/faqs/FAQ.html

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

pgsql-admin by date

Next:From: Andrei BintintanDate: 2003-12-16 17:45:08
Subject: Re: character type modification
Previous:From: Jodi KanterDate: 2003-12-16 17:32:05
Subject: character type modification

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