I have been trying to do exactly that, with this being the closest I can
come:
football=# SELECT a.attname, t.typname, a.attlen, a.atttypmod FROM
pg_class c, pg_attribute a, pg_type t WHERE c.relname = 'tblplayer' AND
a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid ORDER BY
a.attnum;
That is great thank you.
How would I grab the attribute type for an attribute with it so that the
out put would look like
attname atttype
-- --
userid varchar(30)
I know that is not correct but is it possible to get that out put
At 05:27 PM 10/9/00 +0200, you
