pg-custom-types

Custom data types for node-postgres

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
pg-custom-types
003.0.06 years ago7 years agoMinified + gzip package size for pg-custom-types in KB

Readme

pg-custom-types Build Status
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
  });
});