From: | Ketema Harris <ketema(at)gmail(dot)com> |
---|---|
To: | Jean-Christophe Roux <jcxxr(at)yahoo(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: get column default value |
Date: | 2006-11-13 14:59:29 |
Message-ID: | 73E54DDE-B024-49FD-8247-739F9B73532A@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
The default value for a column is just that the value you say is
default. It only come into play when you do an insert into the
table. If you do not provide a value for that column then your
default value is entered.
Now if you set the default value of a column to a sequence, then you
can manage the sequence using the sequence functions: currval,
nextval, and setval. Sequences and their functions are documented in
the pg manual.
On Nov 13, 2006, at 9:49 AM, Jean-Christophe Roux wrote:
> Hello,
> How can I get the default value for a column?
> To change the default value, something like
> ALTER TABLE dummy ALTER COLUMN value SET DEFAULT -12;
> would do the job, but how could I query the value?
>
>
> Thanks in advance
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christophe Roux | 2006-11-13 15:03:52 | Re: get column default value |
Previous Message | Jean-Christophe Roux | 2006-11-13 14:49:14 | get column default value |