On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer.guo@xxxxxxxxx> wrote: > hi ,i got a problem , kinda don't know how to deal with it ,hoping can get > help here ,thanks ! > also to Ashesh ,firstly, thanks for every favor you did. and the postgres > must exist ,maybe just present itself for some reason. when i give the > command " > psql -l template1 " > > it was there. > <<< > List of databases > Name | Owner | Encoding | Collation | Ctype | Access > privileges > -----------+----------+----------+-------------+-------------+----------------------- > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > : > postgres=CTc/postgres > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres > : > postgres=CTc/postgres > test | guo1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/guo1 > : guo1=CTc/guo1 > test1 | guo1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/guo1 > : guo1=CTc/guo1 > : > test1=CTc/guo1 > (4 rows) I think you're confusing the owner with the dbname. there's not postgres db. you can create one: psql template1 create database postgres; -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
