On 20 September 2010 19:54, Carlos Mennens <carlos.mennens@xxxxxxxxx> wrote: > On Mon, Sep 20, 2010 at 2:43 PM, A.M. <agentm@xxxxxxxxxxxxxxxxxxxxx> wrote: >> DEFAULT > > Sorry just to be clear you're saying that I need to enter the command as: > > INSERT INTO table_name DEFAULT VALUES ( > 'data', > 'data', > 'data', > 'data', > '2010-09-20' > ); > Well, you can use the DEFAULT value if you wish: INSERT INTO table_name ( DEFAULT, 'data', 'data', 'data', 'data', '2010-09-20' ); Where the keyword DEFAULT appears, it will, as you'd expect, use the default value for that column. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
