Le ven. 14 janv. 2022 à 12:04, Ray O'Donnell <r...@rodonnell.ie> a écrit :
> On 14/01/2022 10:39, Flaviu2 wrote: > > 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 ? > > If it's any help, running psql with the -E switch will show you the SQL > which psql generates... so then (within psql) issuing the \dt command to > list tables will show you the SQL used. > > Ray. > > Hello, You can use this SQL command to view all the standard table (known as relations): SELECT relname FROM pg_class WHERE relkind = 'r'; And this one for partitioned tables (if you use them): SELECT relname FROM pg_class WHERE relkind = 'p'; HTH, Thomas > -- > Raymond O'Donnell // Galway // Ireland > r...@rodonnell.ie > > >
