Thread: issue creating database in postgresSQL
I'm new to postgresSQL and try to create database. I connected as postgres user/role, I ran create database test1 command without any error message, but don't see test1 database being created when I used \list command to see all databases. Can someone help to shed some light on why? Thanks. -- View this message in context: http://postgresql.nabble.com/issue-creating-database-in-postgresSQL-tp5921658.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
2016-09-18 10:16 GMT+12:00 Thomas <tszhu2003@yahoo.ca>:
I'm new to postgresSQL and try to create database. I connected as postgres
user/role, I ran create database test1 command without any error message,
but don't see test1 database being created when I used \list command to see
all databases. Can someone help to shed some light on why? Thanks.
What command did you use to create the database?
did it return any error?
What PostgreSQL version you're using?
Also, post the output of: \l+
su - postgres
psql
\l+
Lucas