Jerome Lyles <susemail@hawaii.rr.com> writes:
> psql:create.txt4:34: ERROR: type "datetime" does not exist
> Does this mean this datatype doesn't exist on this line (34) or that it
> doesn't exist at all? If it doesn't exist at all what is the correct
> datatype to use here?
It doesn't exist at all (any more). That's an obsolete equivalent for
the more standard datatype TIMESTAMP WITH TIME ZONE.
regards, tom lane