Re: Importing from Access 2000? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Importing from Access 2000?
Date
Msg-id 200304291618.48793.dev@archonet.com
Whole thread Raw
In response to Re: Importing from Access 2000?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
On Tuesday 29 Apr 2003 2:46 pm, Oliver Elphick wrote:
> On Tue, 2003-04-29 at 14:31, Bjørn T Johansen wrote:
> > Well, they are timestamps but they are just using the time part without
> > the date part in the old access db.
> > So I am not sure which type it should be the postgresql db, so any
> > suggestions are appreciated...
>
> There is a TIME data type.

And if in fact they aren't times (e.g. 2pm) , but intervals (e.g. 2 hours 30
mins) then there is an "interval" type.

--
  Richard Huxton


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Backend memory leakage when inserting
Next
From: Tom Lane
Date:
Subject: qsort (was Re: Solaris)