pg-custom-types

Use custom data types with node-postgres.

Installation

npm install pg-custom-types

Documentation

types(pg, connection, name, types, callback)

Fetches the OIDs for the given types.

Parameters

parameter	type	description
fetcher	Object	The query function of the form function (sql, callback)
key	String	A name for the given set of types, used to cache the results. It can be anything.
types	Array	The array of data type names to fetch
callback	Function	The callback to call after the types are fetched

Callback is called with an object containing a lookup table.

{ 21842552: 'geometry',
  21842762: 'geography' }

Example

var types = require('pg-custom-types');
 
types(types.fetcher(pg, connection), 'postgis', ['geometry', 'geography'], (err, oids) {
  if (err) {
    throw err;
  }
 
  console.log(oids.geometry);
  console.log(oids.geography);
 
  pg.setTypeParser(oids.geometry, function (value) {
    // parse geometry type
  });
});