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

Re: Nu-B\Column:Alter type

From: john-paul delaney <jp(at)justatest(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Nu-B\Column:Alter type
Date: 2002-02-22 21:11:42
Message-ID: Pine.LNX.4.21.0202221959390.18423-100000@justatest.com (view raw or flat)
Thread:
Lists: pgsql-novice


On Fri, 22 Feb 2002, Josh Berkus wrote:


How is this done? e.g. I want to change column 8's type.

> Step 0.2:  Edit bad_table.sql to the table definition you want.  


> Hmmm ... I thought that you wanted to change an existing column from
>  DATE to VARCHAR.  
 
Yes you're right, I'm just musing on how a change would be done i.e. do I have to practically rebuild the table or can the change be done more simply... inexperience showing.. thanks for your patience.

/j-p.


-----------------------
 JUSTATEST Art Online
  www.justatest.com




In response to

pgsql-novice by date

Next:From: Doug SilverDate: 2002-02-22 21:36:27
Subject: select IN problem
Previous:From: Lewis BergmanDate: 2002-02-22 20:59:02
Subject: indexes on multiple columns

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