Thread: Emulating "\d" Output
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
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
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 >