>> I'm trying to migrate project working with pgsql-7.2.3 to pgsql-7.3.2.
>> I've found some troubles. The main is, i have type datetime almost in
>> all tables from database. Thus, i've got error when trying create
>> table with such date type. ( And restoring database dump failed ).
>> The question is:
>> What the easy way to restore database?
>> How i can define alias for data type? It would be terrific!
TL> CREATE DOMAIN datetime AS timestamp with time zone;
TL> In the long run you should probably migrate to the SQL-standard datatype
TL> name, but the DOMAIN trick will be useful in the meanwhile.
TL> regards, tom lane
Tom,
Thank you very much!
Regards,
Aleksey