3 ms·

Bringing psql's \d to your web browser

• gmac 2y ago
  I wrote this post (and the npm packages it describes). Happy to answer questions.
• nikita 2y ago
  Postgres \ commands are incredible shortcuts that are a pain to write in sql. E.g. \dt+ translates to SELECT schemaname, tablename, tableowner, tablespace, pg_size_pretty(pg_total_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename))) AS total_size FROM pg_tables ORDER BY pg_total_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename)) DESC;