Thread: can postgresql alter table modify datatype for existing column

From

Flower Sun

Date:

18 March 2003, 16:43:52

Hi, group,

Question 1: Does any one know whether postgresql has "alter table modify datatype for existing column" syntax available for version 7.3.1?

Question 2: Does any one know the command to display DDL for creating postgresql tables from psql client tool?

Thank you,

Jing

Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!