It's
Column | Type | Modifiers
--------------+-----------------------------+-------------------------------------------------------------------
attendanceid | integer | not null default nextval('attendance_attendanceid_seq'::regclass)
entered | date | not null default ('now'::text)::date
timeperiod | character(2) |
timestamp | timestamp without time zone | default now()
On 04/08/2013 06:45 AM, Richard Harley wrote:
I am running the query straight through PSQL so there are no other programs or adapters.
The field definition is just 'timestamp'.
From psql what do you get if you do?:
\d attendance
I did try that as well - no luck :)
Rich
--
Adrian Klaver
adrian.klaver@gmail.com