HomeยปTag: PostgreSQL

Convert PostgreSQL Template0 & Template1 Encoding to UTF8 (SQL_ASCII Incompatible)

After installing Odoo 8 (also known as OpenERP), and other web apps which runs on PortgreSQL databases, you'll be asked to create a new database for your company. However, when creating the database, Odoo returns the following [...]

Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL

In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create Table As which allows easy duplicating of a table with data from another or a few other tables. The [...]