Hi
I have a MySQL application which I am porting to Postgres. I have been
asked to increase the size of a varchar column from 200 chars to 2000.
Normally, in MySQL/Oracle this is done with the alter table modify
column command.
How do I do this in Postgres?
I have just renamed the column, created the new one, copied the data
into it and dropped the renamed column. Is the only way?
All the best
Simon
--
Simon Windsor
Eml: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.