Re: Emulating "\d" Output - Mailing list pgsql-general

From Charles Tassell
Subject Re: Emulating "\d" Output
Date
Msg-id 4.3.2.7.2.20000721141330.00dd6bc0@mailer.isn.net
Whole thread Raw
In response to Emulating "\d" Output  (mjp@ornl.gov)
Responses Re: Emulating "\d" Output  (mjp@ornl.gov)
List pgsql-general
I think this is in the FAQ somewhere.  If you start psql with the -E option
it will show all the queries it uses for any commands, including \d  So
just do something like:

psql -E mydb
\d

And you should see it.  The actual query for \d is
QUERY: SELECT usename, relname, relkind, relhasrules FROM pg_class, pg_user
WHERE usesysid = relowner and ( relkind = 'r' OR relkind = 'i' OR relkind =
'S') and relname !~ '^pg_' and (relkind != 'i' OR relname !~
'^xinx')  ORDER BY relname


At 02:03 PM 7/21/00, you wrote:
>Hi,
>
>Is there a way of generating the same output as \d <tablename>
>with a single SELECT statement using the Postgres
>system table(s?
>
>Thanks,
>Morey Parang
>ORNL


pgsql-general by date:

Previous
From: mjp@ornl.gov
Date:
Subject: Emulating "\d" Output
Next
From: mjp@ornl.gov
Date:
Subject: Re: Emulating "\d" Output