From: | Flaviu2 <flaviu2(at)yahoo(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | List all tables from a specific database |
Date: | 2022-01-14 10:39:29 |
Message-ID: | 754992290.610416.1642156769536@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I work on a project that use Postgre SQL, and I have 0 experience in this regard. I hope to get help here. I need two SQL scripts for Postgre:
1. Get all databases, which I aquired already:
SELECT datname FROM pg_database WHERE datistemplate = false
This one is functional, it's ok.
2. Now, I need to find all tables under a specific database. This one I don't know how to achieve it. Can you help me here ? It is possible ?
For instance, using this SQL script:
SELECT 1, datname FROM pg_database WHERE datistemplate = false
I got:
mydb1mydb2postgres
So far, so good. Of course, mydb1 and mydb2 have been created by me, using:
create database mydb1create database mydb2
Now, which SQL script to use, to retrieve all tables under a database only, but, most important, using SQL script only.
For instance, something like (pseudo-script):
SELECT table_name FROM information_schema.tables WHERE database = 'mydb1'SELECT table_name FROM information_schema.tables WHERE database = 'mydb2'
Kindly thank you.
Flaviu.
From | Date | Subject | |
---|---|---|---|
Next Message | Ray O'Donnell | 2022-01-14 11:04:24 | Re: List all tables from a specific database |
Previous Message | Julien Rouhaud | 2022-01-14 10:23:55 | Re: [Extern] Re: postgres event trigger workaround |