6 ms·
The backslash commands are way better than having to type out SHOW TABLES; or SHOW DATABASES;, or CONNECT DATABASE X. All I have to do is \dt or \c x. It's so m
by keithy 11y ago
The backslash commands are way better than having to type out SHOW TABLES; or SHOW DATABASES;, or CONNECT DATABASE X. All I have to do is \dt or \c x. It's so much better. Can't remember them? Just do \?.
- realusername 11y agoThat'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 :).
- collyw 11y agoThats like trying to say emacs is easier than eclipse. Sure it may be more efficient once you are used to it, but its not more intuitive.
- baq 11y agoeclipse and intuitive shouldn't ever be used in the same sentence. emacs ditto, but calling one more intuitive from another is missing the point by about 1 AU.
- collyw 11y agoEclipse isn't great in that respect, but choosing something from a menu is definitely more intuitive than remembering the cryptic commands in emacs.
- semi-extrinsic 11y ago"The only intuitive interface is the nipple, after that it's all learned." - Bruce Ediger
- neokya 11y ago\? is killer. Thanks a ton, I didn't know that yet. I also find MySQL cli very easy to work. But that's going to change now, it seems.