-
January 13th, 2022, 08:07 AM
#1
Get all tables under a database in Postgre
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 ?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|