Re: List all tables from a specific database

2022-01-14 Thread Flaviu2
Yes, I ran \c mydb1 but I didn't see any SQL script underhood :( On Friday, January 14, 2022, 02:45:52 PM GMT+2, Ray O'Donnell wrote: On 14/01/2022 12:42, Flaviu2 wrote: > Yes, I started psql with -E, and now I see the SQL underhood. Thank you. > > Now I need to

Re: List all tables from a specific database

2022-01-14 Thread Flaviu2
Yes, I started psql with -E, and now I see the SQL underhood. Thank you. Now I need to find how to get and how to select a specific database, I have no experience in Postgre SQL.On Friday, January 14, 2022, 01:04:47 PM GMT+2, Ray O'Donnell wrote: On 14/01/2022 10:39, Flaviu2

Re: List all tables from a specific database

2022-01-14 Thread Flaviu2
database under were created. Flaviu. On Friday, January 14, 2022, 02:08:22 PM GMT+2, Thomas Boussekey wrote: Le ven. 14 janv. 2022 à 12:04, Ray O'Donnell 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 >

List all tables from a specific database

2022-01-14 Thread Flaviu2
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