PostgreSQL Migration Reference
Technical information on PostgreSQL migration (to/from).
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