Re:“Fashion Is Hard. PostgreSQL Is Easy” [video]
by realusername on Thursday June 18, 2015 @09:44AM
(#9738440)
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.
[ Parent
| on HN ]
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video]
by noir_lord on Thursday June 18, 2015 @10:33AM
(#9738715)
I 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.
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video]
by bshimmin on Thursday June 18, 2015 @10:41AM
(#9738778)
Here'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/post...