List all tables from a specific database

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.

Responses

Browse pgsql-general by date

  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