PostgreSQL - Reference and Migration

Technical information on PostgreSQL and its conversion to other databases.

Last Update: PostgreSQL 9.2

• INT, INTEGER
• SERIAL
• TEXT

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

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

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

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

• LIMIT and OFFSET Options

• CREATE DOMAIN
• CREATE TEMPORARY TABLE

• How to Change Database in Query Tool

• Npgsql .NET Data Provider - Getting Started
• Npgsql .NET - Working with Result Sets