Difference between revisions of "Postgres examples"

From lippmann wiki
Jump to: navigation, search
(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;")
 
(No difference)

Latest revision as of 17:13, 10 February 2020

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;