• Home
  • Why SQLines
  • Services
  • Purchase
  • Download
  • Partners
  • Case Studies
  • About
  • Contact Us

Convert Online

Migration to MariaDB

IBM DB2 to MariaDB
MySQL to MariaDB
Oracle to MariaDB
SQL Server to MariaDB
Sybase ASE to MariaDB
Sybase ASA to MariaDB
Informix to MariaDB

Migration to Oracle

IBM DB2 to Oracle
Informix to Oracle
Sybase ASE to Oracle
Sybase ASA to Oracle
SQL Server to Oracle
Teradata to Oracle
PostgreSQL to Oracle
MySQL to Oracle

Oracle PL/SQL to Java
COBOL to Oracle PL/SQL

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
Sybase ASE to SQL Server
Sybase ASA to SQL Server
Sybase ADS to SQL Server
Oracle to SQL Server
MySQL to SQL Server

Migration to MySQL

IBM DB2 to MySQL
Informix to MySQL
Sybase ASE to MySQL
Oracle to MySQL
SQL Server to MySQL

Migration to PostgreSQL

IBM DB2 to PostgreSQL
Informix to PostgreSQL
Sybase ASE to PostgreSQL
Sybase ASA to PostgreSQL
Oracle to PostgreSQL
SQL Server to PostgreSQL

Migration to IBM DB2

SQL Server to IBM DB2

Migration to Redshift

Hadoop to Redshift
Oracle to Redshift
SQL Server to Redshift
Teradata to Redshift

Migration to Snowflake

Hadoop to Snowflake
Oracle to Snowflake
SQL Server to Snowflake
Teradata to Snowflake

Migration to Netezza

Oracle to Netezza

Migration to Greenplum

IBM DB2 to Greenplum
Oracle to Greenplum

Migration to EsgynDB

Oracle to EsgynDB
Teradata to EsgynDB

Application Conversion

Java
C# .NET
PowerBuilder
COBOL

SQLines Data

Overview
Command Line
Configuration File
Connection Strings

Database Reference

Oracle
SQL Server
IBM DB2
MySQL
PostgreSQL
Sybase
Sybase ASA
Informix
Teradata


PostgreSQL - Reference and Migration

Technical information on PostgreSQL and its conversion to other databases.

Last Update: PostgreSQL 9.2

Data Types

  • INT, INTEGER
  • SERIAL
  • TEXT

How To - Data Definition (DDL)

  • Generate IDs (Auto-increment, Identity)
  • OID Columns (Table with OIDS)
  • Create User Defined Type (UDT)

How To - Most Popular Queries and Expressions

  • DATEDIFF - Datetime Difference in Seconds, Days, Months, Weeks etc.
  • DATEADD - Add Interval to Datetime

How To - PL/pgSQL Procedural SQL

  • Stored Procedures and Functions - Getting Started
  • Return a Result Set From Stored Procedure

How To - Database Administration (DBA)

  • Find Out PostgreSQL Version
  • pg_dump - Export Database to SQL Script

Queries - SELECT Statement

  • LIMIT and OFFSET Options

Statements

  • CREATE DOMAIN
  • CREATE TEMPORARY TABLE

pgAdmin Tool

  • How to Change Database in Query Tool

PostgreSQL and C# .NET Applications

  • Npgsql .NET Data Provider - Getting Started
  • Npgsql .NET - Working with Result Sets
  • Copyright © 2010 - 2020. All Rights Reserved. Privacy Statement
  • Driven by DokuWiki