database and table listing
are there any SQL statements which I can type into the psql client to give
a listing of available databases, available tables (within a database), and
to view the structure of a single table.
--
Kindness is a language which the deaf can hear and the blind can read.
-- Mark Twain
-- -- -- -- -- -- -- -- -- --
Stephen Patterson steve@foxx.UKL.net
(Replace UKL with uklinux to reply)
On Wed, Nov 01, 2000 at 07:00:12PM +0000, Stephen Patterson wrote:
are there any SQL statements which I can type into the psql client to give
a listing of available databases,
\l
available tables (within a database),
\d
and to view the structure of a single table.
\d tablename
All of which is in "man psql"...
These aren't SQL statements themselves, but if you start psql with
"-E", you can see the SQL queries which are sent to the backend when
you use them.
Richard
On Wed, Nov 01, 2000 at 07:00:12PM +0000, Stephen Patterson wrote:
are there any SQL statements which I can type into the psql client to give
a listing of available databases, available tables (within a database), and
to view the structure of a single table.
Start psql as 'psql -E' and then try psql internal commands
so you see what queries psql itself generates.
--
marko
On Wed, Nov 01, 2000 at 07:16:16PM +0000, Richard Poole wrote:
All of which is in "man psql"...
Or just do \? at psql prompt :-) \h will give you PostgreSQL SQL statements.
--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744