Re: exploring data

From: Willie Northway <willn(at)diamondbullet(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: exploring data
Date: 2001-06-27 21:25:55
Message-ID: Pine.LNX.4.10.10106271719010.3094-100000@spiderman.diamondbullet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2001-06-27 22:09:26 Re: Re: exploring data
Previous Message Willie Northway 2001-06-27 18:34:20 Re: exploring data