News for hackers. Stuff that matters.
Re:Learn Postgres at the Playground – Postgres compiled to W... by Starlevel001 on Wednesday August 17, 2022 @04:36PM (#32501378)
> now you have to create a database, create a user, grant that user access to the database, setup credentials and start using them.

CREATE ROLE dumbo WITH LOGIN PASSWORD 'fuck';

CREATE DATABASE dumbo OWNER dumbo;

It's that easy.

Re:Learn Postgres at the Playground – Postgres compiled to W... by stuaxo on Wednesday August 17, 2022 @05:02PM (#32501686)
I only have to run these about once every year or two, and have to look them up every time.
Re:Learn Postgres at the Playground – Postgres compiled to W... by rattray on Wednesday August 17, 2022 @04:51PM (#32501532)
Many developers don't run those commands very frequently, so they're easy to forget.