...
Code Block |
---|
CREATE DATABASE db_name OWNER = role_name TEMPLATE = template ENCODING = encoding LC_COLLATE = collate LC_CTYPE = ctype TABLESPACE = tablespace_name CONNECTION LIMIT = max_concurrent_connection WITH ENCODING='UTF8' |
Once you create user & database successfully, you can try to check by
Code Block |
---|
psql -h localhost -U <your_database>username> |
To see the database list
Code Block |
---|
\list |
To see the user list
Code Block |
---|
\du |