ยป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 [...]

By |2016-12-09T08:39:14+08:00December 9th, 2016|Categories: Databases|Tags: |2 Comments

Install Odoo 8 (OpenERP) in CentOS & Red Hat Enterprise Linux

Odoo, previously known as OpenERP, is an open source traditional ERP (Enterprise Resource Planning) business apps which also comes with many additional modules that help to manage the tasks such as building e-commerce websites, point of sales [...]

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 [...]

By |2016-12-09T08:40:19+08:00December 9th, 2016|Categories: Databases|Tags: , , , |8 Comments

Create New Table by Selecting Data from Other Tables with CREATE TABLE AS

By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled or inserted with data from another table or tables retrieved by SELECT statement. The SQL data manipulation language is [...]

By |2016-12-09T08:41:38+08:00December 9th, 2016|Categories: Databases|Tags: , , , , |8 Comments