I need to get all database names, using SQL script only. I have tried:
Code:
SELECT datname FROM pg_database  WHERE datistemplate = false
and seem to work. I got:
Code:
mydb1
mydb2
postgres
mybd1 and mydb2 have been created by me. So far, so good. Now, I need to find all tables under every database, using SQL script only. Is it possible ?