Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

PostgreSQL

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

By |2020-05-25T03:56:16-07:00Modified: May 25, 2020January 7th, 2015|Categories: Databases|Tags: |1 Comment

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: , , , , , |5 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