4 ms·
The command line experience is old school style i.e. to show tables. \c database \dt Versus: use database show tables
by threeseed 2y ago
The command line experience is old school style i.e. to show tables.
\c database
\dt
Versus:
use database
show tables
- dventimi 2y agoThat's psql.
- fhdsgbbcaA 2y agoIt’s also faster to type.
- eYrKEC2 2y agoNot after you have to google, "What's the equivalent of `show tables` in postgres?", because the psql command names are completely arbitrary.
- fhdsgbbcaA 2y agoWhich you need to do exactly once.
- deleted 2y ago[deleted]
- Symbiote 2y agoThey are clearly abbreviations. \c is for connect. \dt is for describe tables.
- mxey 2y ago\? shows the help
- ahoka 2y agoThey kinda make sense if you consider that Postgres was not an SQL database in the beginning. Quirky though.
- rootusrootus 2y agoI assume this is really what it comes down to. If psql added those verbose-but-descriptive commands a whole bunch of people comfortable with mysql would be a lot happier using postgres.
- georgyo 2y agoI started with MySQL in 2006 for my personal projects, but what first won me over to psql was those commands. Today I use CLIs like usql to interact with MySQL and SQLite so I can continue to use those commands. At first glance they may be less obvious, but they are significantly more discoverable. \? Just shows you all of them. In MySQL it always feels like I need to Google it.
- stephenr 2y ago> At first glance they may be less obvious, but they are significantly more discoverable. \? Just shows you all of them. In MySQL it always feels like I need to Google it. In MySQL either `?` or `help` or `\?` will show you the help...