Pg-custom-types NPM

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
  });
});