Re: Postgresql and scripting - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql and scripting
Date
Msg-id 19801.1094652325@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql and scripting  (Jerome Lyles <susemail@hawaii.rr.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: canceling query due to user request
Next
From: Tom Lane
Date:
Subject: Re: How to determine a database is intact?