PostgreSQL quick reference.

CREATE DATABASE <dbname>;
CREATE ROLE <rolename>;
ALTER USER backend WITH PASSWORD '<password>';
ALTER USER backend WITH LOGIN;
ALTER DATABASE <dbname> OWNER TO <rolename>;
GRANT ALL PRIVILEGES ON DATABASE <dbname> TO <rolename>;

-- Reset sequence
ALTER SEQUENCE seq RESTART WITH 1;
 
-- update column to reference sequence
-- (not needed if the column in question is already
-- referenced by the sequence)
UPDATE t SET idcolumn=NEXTVAL('seq');