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 <adrian.kla...@gmail.com> 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
> adrian.kla...@gmail.com

Reply via email to