News for hackers. Stuff that matters.
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.
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...
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by noir_lord on Thursday June 18, 2015 @01:43PM (#9740372)
Thats excellent, thanks :).