SQL Idiom Design Patterns - Postgres OnLine Journal
describes some commond design patterns in sql and postgresql
0 commentsSave Tags: database, how-to, methodology
How to Inherit, Unherit and Merge Inherit - Postgres OnLine Journal
Shows how to use table inheritance in PostgreSQL after the fact.
0 commentsSave Tags: how-to, humor, open source
PostgreSQL 8.3 TSearch Cheat Sheet Overview
Using PostgreSQL 8.3 integrated full-text search capabilities
0 commentsSave Tags: database, how-to, open source
Choosing the right Database Procedural Language PL in PostgreSQL
Brief summary of pros and cons of using PL languages in PostgreSQL and when to use them
0 commentsSave Tags: database, opinion
How to calculate Running Totals and Sums in SQL
Describes ansi SQL standard way of calculating cumulative sums
0 commentsSave Tags: database, how-to
Setting up PostgreSQL as a Linked Server in Microsoft SQL Server 64-bit - Postgres OnLine Journal
Describes how to configure Postgresql as a SQL server 2005 64-bit linked server.
0 commentsSave Tags: database, how-to, open source
REST in PostgreSQL Part 2 B - The REST Server service with PHP 5
Demonstrates simple REST service in PHP
0 commentsSave Tags: database, how-to, open source, php
How to SELECT ALL EXCEPT some columns in a table - Postgres OnLine Journal
Shows how to exclude certain columns from a SELECT query.
0 commentsSave Tags: database, how-to, open source
Constraint Exclusion when it fails to work
Using constraint exclusion in PostgreSQL and what to watch out for.
0 commentsSave Tags: database, how-to, open source
REST in PostgreSQL Part 2 A - The REST Server service with ASP.NET - Postgres OnLine Journal
Example of creating REST webservice in ASP.NET and Mono.NET using C#, VB.NET , MonoBasic against a postgresql databse
0 commentsSave Tags: .net, database, how-to, web services
Showcasing REST in PostgreSQL - The PreQuel - Postgres OnLine Journal
Provides a brief summary of what REST is and where it came from. This is a prequel into a REST implementation using PostgreSQL as back-end database.
0 commentsSave Tags: database, how-to, open source
REST in PostgreSQL Part 1 - The DB components - Postgres OnLine Journal
This part 1 of multi-part series demonstrates setting up pgsql function in PostgreSQL to support a REST web service
0 commentsSave Tags: database, how-to, open source
PLR Part 3: PL/R and Geospatial Data Abstraction Library (GDAL) RGDAL
Describes how to install RGDAL library in R-Statistical environment and call functions from PostgreSQL PL/R language.
0 commentsSave Tags: database, how-to, open source, tools
TSearch Primer - Postgres OnLine Journal
Show how to use TSearch - the full text search engine now fully integrated in PostgreSQL 8.3
0 commentsSave Tags: database, how-to, open source
New Features for PostgreSQL Stored Functions
Goes over some of the key features in programming stored function introduced in PostgreSQL 8.3
0 commentsSave Tags: database, how-to, open source
DML to generate DDL and DCL- Making structural and Permission changes to multiple tables
How to dynamically generate SQL alter database structure with sql
0 commentsSave Tags: database, how-to, open source
GDAL OGR2OGR for Data Loading
Simple technique for data loading into postgresql and other databases
0 commentsSave Tags: database, how-to, open source
How to convert a table column to another data type in Postgresql
The USING syntax is particularly handy because it allows you to control how casts are done. Let us suppose you have a text or varchar field that you... more »
0 commentsSave Tags: database, how-to
PostgreSQL 8.3 is out and the Project Moves On
Details where PostgreSQL is headed and why its a good choice.
0 commentsSave Tags: database, open source
Reading PgAdmin Graphical Explain Plans
Shows some neat snapshots of graphical explain plans in postgresql pgadmin III admin tool.
0 commentsSave Tags: database, how-to, open source
Moving tables from one schema to another - Postgres OnLine Journal
How to move tables from one schema to another in PostgreSQL.
0 commentsSave Tags: database, open source
Using MS Access with PostgreSQL - Postgres OnLine Journal
How to install postgresql odbc driver, use linked tables and pass-thorough queries in Microsoft Access
0 commentsSave Tags: database, microsoft, windows
The Anatomy of PostgreSQL - Part 2 - Database Objects
Brief summary of objects found in a PostgreSQL database
0 commentsSave Tags: database
Setting up PgAgent and Doing Scheduled Backups
Describes how to steup and use postgresql pgagent and provides sample shell scripts for windows and linux for doing PostgreSQL backups.
0 commentsSave Tags: database, how-to, open source, server
Sun Purchasing MySQL and PostgreSQL advances
Commentary on the Sun and MySQL deal as well as new items to look forward to in PostgreSQL
1 commentsSave Tags: database