On Fri, Feb 06, 2004 at 04:53:47PM +, C G wrote:
>
> I'm trying to get a table containing all the user created tables, which
> contains the column name and their types. Basically, I want to be able to
> do "\d all_user_tables" - but I can't use the \d notation.
>
> I tried to combine the p
this query will list every table (with its attributes) in the "public" schema. You could alter the where clause to add more schemas (maybe using IN):
SELECT
N.nspname,
C.relname,
A.attname,
pg_catalog.format_type(a.atttypid, a.atttypmod) AS typeName
FROM
pg_class C,
pg_namespace N,
pg_attribut
