Re: exploring data - Mailing list pgsql-novice

From Willie Northway
Subject Re: exploring data
Date
Msg-id Pine.LNX.4.10.10106271719010.3094-100000@spiderman.diamondbullet.com
Whole thread Raw
In response to exploring data  (Willie Northway <willn@diamondbullet.com>)
Responses Re: Re: exploring data  (Nabil Sayegh <nsmail@sayegh.de>)
List pgsql-novice
After some digging in the source code, namely this file:
"src/bin/psql/describe.c" -> I've found the "real" SQL commands
which the backslash commands use:

to list databases:
\list or \l or
SELECT datname FROM pg_database WHERE datname !~ '^template';

to list tables in the currently used database:
\d or
SELECT relname FROM pg_class WHERE relname!~ '^pg_';

- Willie

----
Willie Northway - Software Developer http://www.willienorthway.com/
Diamond Bullet Design - http://www.diamondbullet.com


pgsql-novice by date:

Previous
From: Willie Northway
Date:
Subject: Re: exploring data
Next
From: Nabil Sayegh
Date:
Subject: Re: Re: exploring data