开发者

Postgresql creating database

Well I installed the latest postgreql database on my Windows 7.

Now I'm trying to create a database via the psql.exe command line

When I 开发者_运维知识库open it, it says

psql: FATAL: database "Jansu" does not exist

So I read somewhere, that when no database is specified, it tried to find database with my username or something.

Anyways..how do i create a new database, when I can't access the commandline.


Read psql syntax. You can specify database, user and other parameters. If it's a new installation, there should be a default database 'postgres', you can connect to that one.

 psql -U postgres postgres 

(In Unix environments you might need to add -h localhost in order to force a TCP connection, otherwise it'd try to use Unix-domain sockets, which might not work for other than the postgres user. )

You can create databases from there, or from the command line with createdb

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜