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;
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 joining column's datatypes do not
match
begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:[EMAIL PROTECTED]
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
