Question

我想利用批量文档建立一个邮政数据库。现在,这样做的正常方法是:

“C:Program filesPostgreSQL9.0increatedb.exe”——U Myadmin Mydat AbseName

以上这一文字创建了一个数据库,其中包含违约数据库参数。然而,我希望建立一个数据库,其参数如下:

   WITH OWNER = Myadmin 
   TEMPLATE = template0 
   ENCODING =  SQL_ASCII 
   TABLESPACE = pg_default
   LC_COLLATE =  C 
   LC_CTYPE =  C 
   CONNECTION LIMIT = -1;

Please tell me how to create a database with the above parameters using Batch files.

让我也知道,如何像这一指挥线一样,使用 file子:

"C:Program FilesPostgreSQL9.0increatedb.exe" -U Myadmin -f C:createDB.sql;

Answer 1

The client program createdb does not support all those options.
Create a file db_create.sql:

CREATE DATABASE MydatAbseName
   WITH OWNER myadmin 
   TEMPLATE template0
   ENCODING  SQL_ASCII 
   TABLESPACE  pg_default
   LC_COLLATE   C 
   LC_CTYPE   C 
   CONNECTION LIMIT  -1;

呼吁:

psql -U postgres postgres -f C:/path/to/db_create.sql

The trick here is to connect to the default maintenance db "postgres" and create the new database from there. I do it with the default superuser named "postgres" in my example.
psql -f executes the SQL commands in the given file.

您也只能执行一个带有<条码>-c的单一指挥系统。 (无相关档案):

psql -U postgres postgres -c "CREATE DATABASE MydatAbseName WITH OWNER Myadmin
EMPLATE template ENCODING  SQL_ASCII  TABLESPACE  pg_default LC_COLLATE   C 
LC_CTYPE  C  CONNECTION LIMIT  -1"

More on creating a database in the fine manual here and here.
More on psql.

On Windows, it looks something like this:

"C:Program FilesPostgreSQLverson_numberinpsql.exe" -U user -f C:/path/to/db_create.sql postgres

The last "postgres" is the name of the default maintenance db. If you want to use it in a batch file you have to answer a password prompt or connect with a user that is allowed access without providing a password. Basics in chapters The Password File and The pg_hba.conf File of the manual. More here:

Run batch file with psql command without password

友情链接