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