createdb with collation "C"

Question

I'm trying to create a PostgreSQL database through PowerShell with collate option as C to address sorting order of fields with special characters using below command:

createdb -U postgres -h localhost -p 5432 -O apm apm -l 'C' -T template0

But seeing below error:

createdb: too many command-line arguments (first is "C")

Postgres version: 9.6.6
OS: Windows 10

yes. one is referring to role and other is referring to database name. I tried below and database got created without issues: 'createdb -U postgres -h localhost -p 5432 -O apm apm'. But I'm unable to create database with collate option C — Vikram, Apr 11 '18 at 20:15
After the database name, should come the description and **that's all**. — Tripp Kinetics, Apr 11 '18 at 20:17
Is it even possible to give the collate option in `createdb`? I don't see anything about it in the docs. — Tripp Kinetics, Apr 11 '18 at 20:18
I guess, yes. [link](https://www.postgresql.org/docs/9.6/static/app-createdb.html) — Vikram, Apr 11 '18 at 20:20
Must be a Windows thing - your command works on my Linux. Have you tried putting the database name last? — Laurenz Albe, Apr 12 '18 at 07:24

score 0 · Answer 1 · answered Apr 11 '18 at 20:23

0

Give this a try:

createdb -U postgres -h localhost -p 5432 -O apm apm -lc-collate='C' -T template0

answered Apr 11 '18 at 20:23

Tripp Kinetics

5,178
2
23
37

Got this error: createdb: too many command-line arguments (first is "-T") – Vikram Apr 11 '18 at 20:24

createdb with collation "C"

1 Answers1