pgadmin3 column edit question - Mailing list pgsql-novice

From
Subject pgadmin3 column edit question
Date
Msg-id 20050225202457.4905.qmail@web52402.mail.yahoo.com
Whole thread Raw
Responses php/pgsql coding question...  (<operationsengineer1@yahoo.com>)
List pgsql-novice
i've had to change the data types of several columns
in pgadmin3.  most of the time, the data type is
unavailable (shaded out) and, therefore, i have to
delete the whole column and recreate it with the
correct data type.  there is no data in the table.

is there a way to change the data type in pgadmin3 w/o
having to recreate the column?

i want to avoid recreating the column b/c it then
messes up my column order.

if anybody knows how to manipulate the order of
columns, i'd be interested in learning that, too.  ;-)

i've already had to do some recreating.

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Boolean
Next
From: "Oisin Glynn"
Date:
Subject: Re: pgadmin3 column edit question