pgadmin3 column edit question

From: <operationsengineer1(at)yahoo(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: pgadmin3 column edit question
Date: 2005-02-25 20:24:57
Message-ID: 20050225202457.4905.qmail@web52402.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message MaXX 2005-02-25 21:40:23 Re: pgadmin3 column edit question
Previous Message Tom Lane 2005-02-25 20:12:47 Re: Boolean