5 ms·
What syntax do you have in mind? Can you give sone example of what you see as easier in MySQL than Postgres? Genuinely curious, I don't have money in that game
by akavel 8y ago
What syntax do you have in mind? Can you give sone example of what you see as easier in MySQL than Postgres? Genuinely curious, I don't have money in that game
- apapli 8y agoI recall having to type /d from the command prompt to show databases (or something like that). I prefer “show databases”.
- mrep 8y agoHaha, same. When I first used a postgres database, I got super annoyed trying to figure out how to simply show the databases and tables as I kept trying to use show and describe.
- petepete 8y agoThe standard way to do this would be to query `information_schema. tables`. PostgreSQL's approach isn't the most intuitive but it's well documented and very powerful. A few aliases could probably help, it's good they've added `quit`/,`exit` this time around.
- mgkimsal 8y agoi can say that setting up user accounts and permissions to get up and running is, to me, still easier under mysql, because you connect to mysql as root, and do the rest from inside. postgresql still seems to have 2 ways, but the majority of tutorials will demonstrate the "become the postgres user and add unix-level accounts". Things like having a unix-level "adduser" program that manages pg stuff is... odd to me, because it's not 'self-contained' in the app. It's more system-level admin stuff I need to do or be aware of. Whenever I bring this up, I get push back that I'm doing it wrong, and that of course you can just create user accounts from within pg itself via psql, and ... all other sort of attendant feedback. This approach had not seemed to be the norm/default approach, nor the one that was in multiple postgres books I had 10 years ago. I use pg on some projects, but am no expert in it.