EOF

psql -h you_dp_ip -U postgres -p 5432  << EOF
CREATE DATABASE "yourdbname";
CREATE USER yourusername WITH PASSWORD yourpassword;
GRANT ALL PRIVILEGES ON DATABASE "yourdbname" to yourusername;
GRANT ALL PRIVILEGES ON SCHEMA public to yourusername;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO yourdbname;
EOF

Related:

ALTER SEQUENCE
COPY 23038138
CREATE INDEX
ALTER TABLE
ERROR:  role "NONEXITSROLE" does not exist
WARNING:  no privileges could be revoked for "public"
REVOKE
WARNING:  no privileges were granted for "public"
GRANT
ERROR:  role "your_sole" does not exist

Related

• eof

See also

• cat, tac, more, less, tail, mtail, echo, stdin, tr, column, paste, truncate, logrotate, xzcat pv, progress, sort, ncat, virt-cat, awk, join, col, fold, tee, sponge, nfs-cat, journalctl, ccat, icat, EOF, lolcat
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE