3 ms·
That's also the problem I have, \dt,\c just don't make sense at all and I never remember them whereas 'SHOW TABLES' does not even need explanations. It's also t
by realusername 11y ago
That's also the problem I have, \dt,\c just don't make sense at all and I never remember them whereas 'SHOW TABLES' does not even need explanations. It's also the same thing with the unix users, I never fully understood how postgres handles user permissions. I would say that Postgres itself is really really good but the tooling around is just not there yet.
- noir_lord 11y agoI just remembered it as \d as display and \dt as display tables. I often invent mnemonics that only mean something to me until muscle memory kicks in.
- bshimmin 11y agoHere's a nice one-page cheat sheet, of which about 75% you will probably never need to use: http://www.postgresonline.com/downloads/special_feature/postgresql83_psql_cheatsheet.pdf http://www.postgresonline.com/downloads/special_feature/post...
- noir_lord 11y agoThats excellent, thanks :).