Aleksey Serba <aleksey(at)caj(dot)spb(dot)ru> writes:
> 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!
CREATE DOMAIN datetime AS timestamp with time zone;
In the long run you should probably migrate to the SQL-standard datatype
name, but the DOMAIN trick will be useful in the meanwhile.
regards, tom lane