can postgresql alter table modify datatype for existing column - Mailing list pgsql-general

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