Create

• create role USERNAME with login password 'PASSWORD';
• create database DATABASE_NAME owner USERNAME;
• create table
• create index

Related

• createdb command
• Amazon Redshift: show permissions
• has_schema_privilege

See also

• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql