Postgres Pro
Downloads
Home   >   mailing lists

change varchar(10) to varchar() - Mailing list pgsql-novice

From
Subject change varchar(10) to varchar()
Date
Msg-id 20050804161842.22651.qmail@web33314.mail.mud.yahoo.com
Whole thread Raw
In response to using interval in a query with a column for the interval value?  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
Responses Re: change varchar(10) to varchar()  (Jaime Casanova <systemguards@gmail.com>)
Re: change varchar(10) to varchar()  (Gnanavel S <s.gnanavel@gmail.com>)
List pgsql-novice
Tree view 
is there a sql command to change a field data type
from varchar(10) to varchar()?

i tried to do this in pgadmin3, but when i deleted the
length (maximum characters) attribute, the OK button
stayed grayed out and inactive.  as an aside, the OK
button becomes active when the length attribute is
changed...  but turns gray when it is deleted
altogether.

i don't want to put any arbitrary constraints on my
s/n field - especially since there is no performance
benefit in doing so per the manual.

tia...

ps - i can delete and recreate the table with no
problems - but i would prefer to learn something for
future reference, if possible.

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

pgsql-novice by date:

Previous
From: "Walker, Jed S"
Date:
Subject: using interval in a query with a column for the interval value?
Next
From: "Adam O'Toole"
Date:
Subject: connection string - DNS