get column default value

[Jean-Christophe Roux <jcxxr@xxxxxxxxx>]

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