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

Re: Nu-B\Column:Alter type

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: john-paul delaney <jp(at)justatest(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Nu-B\Column:Alter type
Date: 2002-02-22 17:18:08
Message-ID: web-700730@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-novice
John-paul,

>  How do I change a column from date type to text?

This functionality is not supported in version 7.2 or earlier.  You
 will have to drop and re-create the table:

1. CREATE TABLE temp1 AS
	SELECT * FROM bad_table;
2. DROP TABLE bad_table;
3. CREATE TABLE bad_table;
4. INSERT INTO bad_table SELECT * FROM temp1;
5. DROP TABLE temp1

-Josh Berkus

In response to

Responses

pgsql-novice by date

Next:From: Willie StephensDate: 2002-02-22 17:19:35
Subject: postgres.init
Previous:From: Josh BerkusDate: 2002-02-22 17:15:23
Subject: Re: Nu-B\psql:Command Recall,Repeat?

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