Re: Emulating "\d" Output

Thanks, Charles. I just tried and it works great.

Morey

On Fri, Jul 21, 2000 at 02:17:03PM -0300, Charles Tassell wrote:
> 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
>