Click here to Skip to main content
15,311,104 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get all tables under a database in Postgre Pin
CHill6014-Jan-22 1:16
mveCHill6014-Jan-22 1:16 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 1:47
Member_Flaviu14-Jan-22 1:47 
GeneralRe: Get all tables under a database in Postgre Pin
Victor Nijegorodov14-Jan-22 2:05
MemberVictor Nijegorodov14-Jan-22 2:05 
AnswerRe: Get all tables under a database in Postgre Pin
Richard MacCutchan13-Jan-22 23:39
mveRichard MacCutchan13-Jan-22 23:39 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 0:06
Member_Flaviu14-Jan-22 0:06 
GeneralRe: Get all tables under a database in Postgre Pin
Richard MacCutchan14-Jan-22 0:13
mveRichard MacCutchan14-Jan-22 0:13 
GeneralRe: Get all tables under a database in Postgre Pin
_Flaviu14-Jan-22 3:32
Member_Flaviu14-Jan-22 3:32 
QuestionList all tables from a specific database Pin
_Flaviu12-Jan-22 0:41
Member_Flaviu12-Jan-22 0:41 
How can I list all tables from a specific database in PostGre SQL ?

Lets say I have 3 databases, and I have several tables in every one each of them. How can I retrieve the table names for every database I have, using SQL command ?

With following command:

SQL
SELECT datname FROM pg_database	WHERE datistemplate = false


SQL
I got:
db_name
post_flaviu
postgres
test

Now, how can I find all tables under eevry db from above ?

modified 12-Jan-22 7:16am.

AnswerRe: List all tables from a specific database Pin
Peter_in_278012-Jan-22 1:18
professionalPeter_in_278012-Jan-22 1:18 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 1:35
Member_Flaviu12-Jan-22 1:35 
AnswerRe: List all tables from a specific database Pin
k505412-Jan-22 1:35
mvek505412-Jan-22 1:35 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 1:59
Member_Flaviu12-Jan-22 1:59 
GeneralRe: List all tables from a specific database Pin
k505412-Jan-22 4:13
mvek505412-Jan-22 4:13 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 4:32
Member_Flaviu12-Jan-22 4:32 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 4:39
mveRichard MacCutchan12-Jan-22 4:39 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 5:19
Member_Flaviu12-Jan-22 5:19 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 5:41
mveRichard MacCutchan12-Jan-22 5:41 
GeneralRe: List all tables from a specific database Pin
_Flaviu12-Jan-22 6:16
Member_Flaviu12-Jan-22 6:16 
GeneralRe: List all tables from a specific database Pin
Richard MacCutchan12-Jan-22 6:43
mveRichard MacCutchan12-Jan-22 6:43 
QuestionWampServer localhost Pin
_Flaviu6-Jan-22 6:59
Member_Flaviu6-Jan-22 6:59 
AnswerRe: WampServer localhost Pin
Graham Breach6-Jan-22 21:10
MemberGraham Breach6-Jan-22 21:10 
GeneralRe: WampServer localhost Pin
_Flaviu6-Jan-22 23:53
Member_Flaviu6-Jan-22 23:53 
QuestionSQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 4:20
Member_Flaviu4-Jan-22 4:20 
AnswerRe: SQLite sqlite_schema missing Pin
Richard Deeming4-Jan-22 4:40
mveRichard Deeming4-Jan-22 4:40 
GeneralRe: SQLite sqlite_schema missing Pin
_Flaviu4-Jan-22 7:16
Member_Flaviu4-Jan-22 7:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.