There is also INFORMATION_SCHEMA which is SQL standard and extremely easy to use.
On Fri, Jan 14, 2022, 1:08 PM Thomas Boussekey <thomas.bousse...@gmail.com> wrote: > > > 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 >> >> >>
