TypeScript for pg-promise

Complete TypeScript ambient declarations for pg-promise version 5.2.1 or later.

Inclusion

Since all TypeScript files are distributed with the library, the simplest way to reference it is like this:

/// <reference path='../node_modules/pg-promise/typescript/pg-promise' />

Version 4.3.2 and later supports Typings, so it can be added to your project with this command:

$ typings install --save --global github:vitaly-t/pg-promise

Then you can also use a generic reference:

/// <reference path='../typings/index' />

Usage

/// <reference path='../node_modules/pg-promise/typescript/pg-promise' />

import * as pgPromise from 'pg-promise';

var pgp = pgPromise({
    // Initialization Options
});

var cn = 'postgres://username:password@host:port/database';

var db = pgp(cn);

Example of compiling into JavaScript:

$ tsc myApp.ts --target es6 --module commonjs

And if you want to make full use of a custom promise library, see file ext-promise.d.ts.

Protocol Extensions

The library supports protocol extensions via event extend, which is a special case when it comes to TypeScript, as it dynamically extends the protocol during its callback, which in TypeScript implies type casting.

In order to support dynamic protocol extensions automatically, you need to mirror the protocol extensions through an interface, and then re-cast the database object with it, as shown below.

/// <reference path='../node_modules/pg-promise/typescript/pg-promise' />

// importing as 'pgPromise' helps IntelliSense inspection;
import * as pgPromise from 'pg-promise';

// your protocol extensions:
interface IExtensions {
    findUser(userId:number):Promise<any>;
}

// pg-promise initialization options:
var options = {
    extend: obj=> {
        obj.findUser = userId=> {
            return obj.one('SELECT * FROM Users WHERE id=$1', userId);
        }
    }
};

var cn = 'postgres://username:password@host:port/database';

// initializing the library:
var pgp:pgPromise.IMain = pgPromise(options);

// database object with extensions:
var db = <pgPromise.IDatabase<IExtensions>&IExtensions>pgp(cn);

// now you can use the extensions everywhere (including tasks and transactions):
db.findUser(123).then(...);

Alternatively, you can create the extended db object like this:

var db = pgp<IExtensions>(cn);

The result is identical, but some IntelliSense implementations may struggle to inspect such type correctly.

And if you want strict initialization options, with inline type casting, you can do this:

// extended initialization:
var pgp = pgPromise<IExtensions>({
    extend: obj=> {
        obj.findUser = userId=> {
            return obj.one('SELECT * FROM Users WHERE id=$1', userId);
        }
    }
});

For a more complete and advanced example of using pg-promise with TypeScript, check out pg-promise-demo.