Hi All,

Is it possible to set a default values as 'timestamp without time zone'
in a column ?
I'd like to insert automatically insert the date of insertion...

Thanks
Cedric

Search Discussions

  • Andreas Kretschmer at Jan 15, 2008 at 8:50 am

    am Tue, dem 15.01.2008, um 9:28:45 +0100 mailte Cedric BUSCHINI folgendes:
    Hi All,

    Is it possible to set a default values as 'timestamp without time zone'
    in a column ?
    Yes, you can use 'default now()' or 'default current_date' or some other
    values within the table-definition.

    I suggest you should use timestamptz, timestamp WITH timezone.


    Andreas
    --
    Andreas Kretschmer
    Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
    GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 15, '08 at 8:28a
activeJan 15, '08 at 8:50a
posts2
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase