RE: Can I get the default value for an attribute (field) ?

If you start psql with the -E option you'll see it generates a query
similar to the following:

SELECT substring(d.adsrc for 128) FROM pg_attrdef d, pg_class c
WHERE c.relname = 'my_table' AND c.oid = d.adrelid NAD d.adnum = X

where my_table is the table in question and X is the column number
within that table.

Hope that helps,

Mike Mascari
mascarm@mascari.com

-----Original Message-----
From:    Joel Burton [SMTP:jburton@scw.org]
Sent:    Sunday, April 01, 2001 5:25 PM
To:    pgsql-general@postgresql.org
Subject:    [GENERAL] Can I get the default value for an attribute
(field) ?


I'm building a GUI for a PostgreSQL database. In the DB, many fields
have
default values (a few are complicated, like the results of a
sequence, but
most are simple things like FALSE or 0 or such.)

Is there a way to get what the default value for a field would be
when a
new record is added? For some tables, I could (behind the users back)
add
a row, grab the values given in each column, delete the row, then
present these as 'default' values; however, in most tables, there are
columns that cannot be null and do not have default values, therefore
I
can't just add a row using the default-only values.

I've been looking around for a miraculous SELECT
default_value(table.class) function, but can't seem to find it. Any
ideas?

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html