From: | Jean-Christophe Roux <jcxxr(at)yahoo(dot)com> |
---|---|
To: | Ketema Harris <ketema(at)gmail(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: get column default value |
Date: | 2006-11-13 15:03:52 |
Message-ID: | 20061113150352.91895.qmail@web35303.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
I understand that but I need to build an interface so that my user can change the default values of some table/columns. So I need a way to query the current default value to show the user what it is currently. For instance, let's say I have a table products and there is a column price and the default price is $199, I'd like to get that $199 and give my user the opportunity to update that value. The column does not have any sequence attached to it.
JCR
----- Original Message ----
From: Ketema Harris <ketema(at)gmail(dot)com>
To: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Sent: Monday, November 13, 2006 9:59:29 AM
Subject: Re: [PHP] get column default value
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 | Erik Jones | 2006-11-13 15:19:24 | Re: get column default value |
Previous Message | Ketema Harris | 2006-11-13 14:59:29 | Re: get column default value |