Re: Postgresql and scripting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerome Lyles <susemail(at)hawaii(dot)rr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql and scripting
Date: 2004-09-08 14:05:25
Message-ID: 19801.1094652325@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jerome Lyles <susemail(at)hawaii(dot)rr(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-09-08 14:11:57 Re: How to determine a database is intact?
Previous Message Tom Lane 2004-09-08 14:00:23 Re: ERROR: canceling query due to user request