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
精彩评论