Re:Postgres 11 – A First Look
by apapli on Saturday September 22, 2018 @01:34AM
(#18044645)
I recall having to type /d from the command prompt to show databases (or something like that). I prefer “show databases”.
[ Parent
| on HN ]
Haha, same. When I first used a postgres database, I got super annoyed trying to figure out how to simply show the databases and tables as I kept trying to use show and describe.
The standard way to do this would be to query `information_schema. tables`.
PostgreSQL's approach isn't the most intuitive but it's well documented and very powerful. A few aliases could probably help, it's good they've added `quit`/,`exit` this time around.