default | grid-3 | grid-2

Post per Page

How to create a database in PostgreSQL

Today I needed to create a database with SQL_ASCII encoding.

Here is the command I used:

CREATE DATABASE MyDB ENCODING 'SQL_ASCII' TEMPLATE template0;
I had to use template0 because template1 was set to UTF8.

I still need to dig in on the templates and what they are all about.

No comments

Error Page Image

Error Page Image

Oooops.... Could not find it!!!

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage