Thread: Domains
View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 08:26 AM
Peter
 
Posts: n/a
Default Domains

Hello,

I am migrating to postgresql from another database. I want to take
advantage of using domains. Let's suppose I create domain
'email'(varchar 128). Then I change my mind and want to increase all
columnst that have type 'emaill' to varchar(255). How do I change the
domain 'email' to the new datatype. I can not figure how to do it with
"alter domain" syntax.

Thanks in advance for your help :-)

Kind regards,

Peter



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote