Re: [GENERAL] Re: [GENERAL] hi，for help! - Mailing list pgsql-general

On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer.guo@gmail.com> 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;