RN] list users
\l list all databases (add "+" for more detail)
\z [PATTERN] list table, view, and sequence access privileges (same as
\dp)
Hope this would answer your query.
From: Mondi Ravi <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Subject: [ADMIN] how
Mondi Ravi napisał(a):
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
See tables and views of system catalogs:
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
and use just SELECT statements on them to get what
use tables/views in scheme pg_catalog/information_schema
try
select * from pg_catalog.pg_database;
select * from pg_catalog.pg_user;
select * from pg_catalog.pg_tables;
Mondi Ravi schrieb:
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
you
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
yours sincerely
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your jo
