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 8 Apr 2013, at 14:48, Adrian Klaver <[email protected]> wrote:
> 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
> [email protected]
