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 want.
You may use some of:
http://www.postgresql.org/docs/8.2/interactive/functions-info.html
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html
functions in these statements.
---------------------------(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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
