Hi,
I found some inconsistency on WITH keyword:
1) => \h CREATE TABLE
[...]
[ WITH ( storage_parameter [= value] [, ... ] ) ]
[...]
"=" is required
2) => \h CREATE ROLE
Command: CREATE ROLE
Description: define a new database role
Syntax:
CREATE ROLE name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
[...] | IN ROLE rolename [, ...] | IN GROUP rolename [, ...] | ROLE rolename [, ...] | ADMIN rolename [, ...]
|USER rolename [, ...] | SYSID uid
"=" is not available
3) => \h CREATE DATABASE
Command: CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner ] [ TEMPLATE [=] template ] [ ENCODING [=]
encoding] [ LC_COLLATE [=] lc_collate ] [ LC_CTYPE [=] lc_ctype ] [ TABLESPACE [=]
tablespace] [ CONNECTION LIMIT [=] connlimit ] ]
"=" is optional
Cheers,
Robert