EOF

From wikieduonline
Revision as of 13:05, 23 June 2022 by Welcome (talk | contribs) (Created page with " psql -h you_dp_ip -U postgres -p 5432 << EOF CREATE DATABASE "yourdbname"; CREATE USER yourusername WITH PASSWORD yourpassword; GRANT ALL PRIVILE...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


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


eof

Advertising: