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

By |2020-05-25T03:56:16-07:00Modified: May 25, 2020January 7th, 2015|Categories: Databases|Tags: |3 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 [...]

By |2020-09-09T07:45:29-07:00Modified: September 9, 2020January 7th, 2015|Categories: Enterprise Solutions|Tags: , , , , , |6 Comments

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

By |2020-06-12T04:46:42-07:00Modified: June 12, 2020March 18th, 2007|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 [...]

By |2020-06-07T14:50:19-07:00Modified: June 7, 2020August 23rd, 2006|Categories: Databases|Tags: , , , , |8 Comments
Go to Top