Postgres examples

From lippmann wiki
Revision as of 17:13, 10 February 2020 by Maarten (talk | contribs) (Created page with "create a basic table with utf8 encoding CREATE DATABASE "example" WITH OWNER "user" \ ENCODING 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' \ TEMPLATE template0;")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

create a basic table with utf8 encoding

CREATE DATABASE "example" WITH OWNER "user" \
ENCODING 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' \
TEMPLATE template0;