Features I'd Like in PostgreSQL

Re:Features I'd Like in PostgreSQL by arp242 on Sunday January 29, 2023 @03:34PM (#34572428)

You can use "select * from pg_stat_user_tables" etc.

Admittedly the internal tables and views have a bit of a learning curve and are a little bit obscure (and inconsistent) at times, but it's much nicer and much more flexible.

The CLI stuff like \d are just "aliases" for queries; \set echo_hidden shows them.

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by bornfreddy on Monday January 30, 2023 @11:38AM (#34582260)

Of course you can, but that is beside the point. Convenience matters - besides, these approaches can coexist, adding those simple queries (as aliases) should be trivial.

[ Parent | on HN ]

Re:Features I'd Like in PostgreSQL by arp242 on Monday January 30, 2023 @02:48PM (#34585402)

SHOW has well-defined consistent semantics. Adding "special shortcuts" doesn't seem like much of an improvement.

From the CLI \d etc. seems just as easy (easier actually), and you can add your own shortcuts if you want.

From outside the CLI, this sort of introspection is rare enough I don't really see the point in making special shortcuts for it.

[ Parent | on HN ]