Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id A4C549FA1DB for ; Mon, 13 Nov 2006 10:49:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 72446-06 for ; Mon, 13 Nov 2006 10:49:17 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web35307.mail.mud.yahoo.com (web35307.mail.mud.yahoo.com [66.163.179.101]) by postgresql.org (Postfix) with SMTP id 35D959FA18A for ; Mon, 13 Nov 2006 10:49:15 -0400 (AST) Received: (qmail 83396 invoked by uid 60001); 13 Nov 2006 14:49:14 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type; b=XhtLyMAGNXGAKU6ZCgWdU+oO+ME3CYlaEfUJ2p1Hrj7NY5NddiI81HH+VbGFFQuL1hRtva8rdwJG5rivXIT3OjDGD3HTB8iMYBPWus0KOMO6PH/B1qhFyo0SmxunsPWQM8v4q3lcuYYu0KtG9ZcD9nJsbuS3T71YBbh/LMXsZQQ= ; Message-ID: <20061113144914.83394.qmail@web35307.mail.mud.yahoo.com> Received: from [74.98.189.48] by web35307.mail.mud.yahoo.com via HTTP; Mon, 13 Nov 2006 06:49:14 PST Date: Mon, 13 Nov 2006 06:49:14 -0800 (PST) From: Jean-Christophe Roux Subject: get column default value To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-759848485-1163429354=:82336" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.616 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200611/41 X-Sequence-Number: 3658 --0-759848485-1163429354=:82336 Content-Type: text/plain; charset=ascii Content-Transfer-Encoding: quoted-printable Hello,=0AHow can I get the default value for a column?=0ATo change the defa= ult value, something like=0AALTER TABLE dummy ALTER COLUMN value SET DEFAUL= T -12;=0Awould do the job, but how could I query the value?=0A=0A=0AThanks = in advance=0A=0A=0A=0A --0-759848485-1163429354=:82336 Content-Type: text/html; charset=ascii Content-Transfer-Encoding: quoted-printable
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 t= he value?


Thanks in advance

--0-759848485-1163429354=:82336--