{"_id":"pg-types","_rev":"4091694","name":"pg-types","description":"Query result type converters for node-postgres","dist-tags":{"latest":"4.1.0"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"time":{"modified":"2025-12-02T22:23:19.000Z","created":"2014-03-15T20:34:58.912Z","4.1.0":"2025-07-30T15:37:01.820Z","4.0.2":"2024-01-22T22:47:38.253Z","4.0.1":"2023-02-15T21:38:53.247Z","4.0.0":"2022-01-31T19:15:39.078Z","3.0.1":"2020-08-04T23:07:56.493Z","3.0.0":"2019-11-12T21:38:49.013Z","2.2.0":"2019-08-07T01:15:33.099Z","2.1.0":"2019-07-05T20:29:20.039Z","2.0.1":"2019-04-04T14:40:45.065Z","2.0.0":"2019-01-08T21:16:40.074Z","1.13.0":"2017-11-15T14:12:03.918Z","1.12.1":"2017-08-21T16:14:59.958Z","1.12.0":"2017-05-26T18:37:35.557Z","1.11.0":"2016-04-22T17:56:26.878Z","1.10.0":"2015-08-03T19:11:46.096Z","1.9.0":"2015-07-30T13:42:36.046Z","1.8.0":"2015-07-30T04:17:38.586Z","1.7.0":"2015-02-21T15:57:53.587Z","1.6.0":"2014-10-15T19:33:38.127Z","1.5.0":"2014-10-01T18:34:03.862Z","1.4.0":"2014-07-13T16:27:28.660Z","1.3.0":"2014-06-04T13:55:26.129Z","1.2.0":"2014-05-12T13:50:03.137Z","1.1.0":"2014-05-12T13:41:28.601Z","1.0.0":"2014-03-15T20:34:58.912Z"},"users":{},"author":{"name":"Brian M. Carlson"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"versions":{"4.1.0":{"name":"pg-types","version":"4.1.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","generate":"docker compose --project-directory generator run --rm generator","lint":"standard","test":"npm run test-js && npm run test-ts && npm run lint","test-js":"tape test/*.js | tap-spec","test-ts":"tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"@types/node":"^14.14.33","codecov":"^3.8.1","nyc":"^15.1.0","open-cli":"^6.0.1","pg":"^8.11.3","standard":"^16.0.3","tap-spec":"^5.0.0","tape":"^5.2.2","tsd":"^0.14.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~3.0.1","postgres-bytea":"~3.0.0","postgres-date":"~2.1.0","postgres-interval":"^3.0.0","postgres-range":"^1.1.1"},"engines":{"node":">=10"},"_id":"pg-types@4.1.0","gitHead":"26bfe645a8ddc0c73830b1b8c63f2c4f8265b24f","types":"./index.d.ts","_nodeVersion":"22.14.0","_npmVersion":"11.4.2","dist":{"shasum":"49138d5ff1c94634d7eed42aa9ccba78ea2e52f0","size":6596,"noattachment":false,"key":"/pg-types/-/pg-types-4.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-4.1.0.tgz"},"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/pg-types_4.1.0_1753889821648_0.7706212068626346"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2025-07-30T15:37:01.820Z","publish_time":1753889821820,"_source_registry_name":"default","_cnpm_publish_time":1753889821820},"4.0.2":{"name":"pg-types","version":"4.0.2","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","lint":"standard","test":"tape test/*.js | tap-spec && npm run test-ts && npm run lint","test-ts":"tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"@types/node":"^14.14.33","codecov":"^3.8.1","nyc":"^15.1.0","open-cli":"^6.0.1","standard":"^16.0.3","tap-spec":"^5.0.0","tape":"^5.2.2","tsd":"^0.14.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~3.0.1","postgres-bytea":"~3.0.0","postgres-date":"~2.1.0","postgres-interval":"^3.0.0","postgres-range":"^1.1.1"},"engines":{"node":">=10"},"_id":"pg-types@4.0.2","gitHead":"37606f8111b91ef6237bc10abaf671cd078179eb","types":"./index.d.ts","_nodeVersion":"20.10.0","_npmVersion":"10.2.3","dist":{"shasum":"399209a57c326f162461faa870145bb0f918b76d","size":6053,"noattachment":false,"key":"/pg-types/-/pg-types-4.0.2.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-4.0.2.tgz"},"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_4.0.2_1705963658091_0.6193254056607904"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2024-01-22T22:47:38.253Z","publish_time":1705963658253,"_source_registry_name":"default","_cnpm_publish_time":1705963658253},"4.0.1":{"name":"pg-types","version":"4.0.1","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","lint":"standard","test":"tape test/*.js | tap-spec && npm run test-ts && npm run lint","test-ts":"tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"@types/node":"^14.14.33","codecov":"^3.8.1","nyc":"^15.1.0","open-cli":"^6.0.1","standard":"^16.0.3","tap-spec":"^5.0.0","tape":"^5.2.2","tsd":"^0.14.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~3.0.1","postgres-bytea":"~3.0.0","postgres-date":"~2.0.1","postgres-interval":"^3.0.0","postgres-range":"^1.1.1"},"engines":{"node":">=10"},"types":"./index.d.ts","gitHead":"8d2200fd9cecf41f40acc1432c01a316178e711f","_id":"pg-types@4.0.1","_nodeVersion":"18.7.0","_npmVersion":"9.4.0","dist":{"shasum":"31857e89d00a6c66b06a14e907c3deec03889542","size":6010,"noattachment":false,"key":"/pg-types/-/pg-types-4.0.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-4.0.1.tgz"},"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_4.0.1_1676497133019_0.07713311083648411"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2023-02-15T21:38:53.247Z","publish_time":1676497133247,"_cnpm_publish_time":1676497133247},"4.0.0":{"name":"pg-types","version":"4.0.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","lint":"standard","test":"tape test/*.js | tap-spec && npm run test-ts && npm run lint","test-ts":"tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"@types/node":"^14.14.33","codecov":"^3.8.1","nyc":"^15.1.0","open-cli":"^6.0.1","standard":"^16.0.3","tap-spec":"^5.0.0","tape":"^5.2.2","tsd":"^0.14.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~3.0.1","postgres-bytea":"~3.0.0","postgres-date":"~2.0.1","postgres-interval":"^3.0.0","postgres-range":"^1.1.1"},"engines":{"node":">=10"},"types":"./index.d.ts","gitHead":"e018c0502fdc165ad9616cacc597f91884e0f183","_id":"pg-types@4.0.0","_nodeVersion":"16.10.0","_npmVersion":"8.3.1","dist":{"shasum":"85edef788ed13acad990ce233b8dfa995552b5d9","size":6049,"noattachment":false,"key":"/pg-types/-/pg-types-4.0.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-4.0.0.tgz"},"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_4.0.0_1643656538862_0.2500610098867213"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2022-01-31T19:15:52.882Z","publish_time":1643656539078,"_cnpm_publish_time":1643656539078},"3.0.1":{"name":"pg-types","version":"3.0.1","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","lint":"standard","test":"tape test/*.js | tap-spec && npm run test-ts && npm run lint","test-ts":"tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"codecov":"^3.5.0","nyc":"^14.1.1","open-cli":"^5.0.0","standard":"^14.3.1","tap-spec":"^5.0.0","tape":"^4.0.0","tsd":"^0.9.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~2.0.0","postgres-bytea":"~3.0.0","postgres-date":"~1.0.4","postgres-interval":"^1.1.0"},"engines":{"node":">=8"},"gitHead":"4e494567d94b214d7dc68b124bdcfd00e88804f8","_id":"pg-types@3.0.1","_nodeVersion":"12.16.2","_npmVersion":"6.14.5","dist":{"shasum":"90c15b1034365ff0fd9007f6ea794ec85318968d","size":5959,"noattachment":false,"key":"/pg-types/-/pg-types-3.0.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-3.0.1.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_3.0.1_1596582476346_0.39595263493657695"},"_hasShrinkwrap":false,"publish_time":1596582476493,"_cnpm_publish_time":1596582476493},"3.0.0":{"name":"pg-types","version":"3.0.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"coverage":"nyc --reporter=html npm test && open-cli coverage/index.html","coverage-ci":"nyc --reporter=lcov npm test && codecov","lint":"if-node-version '>= 8' standard 'lib/**'","test":"tape test/*.js | tap-spec && npm run test-ts && npm run lint","test-ts":"if-node-version '>= 8' tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"codecov":"^3.5.0","if-node-version":"^1.1.1","nyc":"^14.1.1","open-cli":"^5.0.0","standard":"^14.3.1","tap-spec":"^5.0.0","tape":"^4.0.0","tsd":"^0.9.0"},"dependencies":{"pg-int8":"1.0.1","pg-numeric":"1.0.2","postgres-array":"~2.0.0","postgres-bytea":"~2.0.0","postgres-date":"~1.0.4","postgres-interval":"^1.1.0"},"engines":{"node":">=8"},"gitHead":"8dbd27c71903e6423df1194aace0bfe5863f950a","_id":"pg-types@3.0.0","_nodeVersion":"12.11.1","_npmVersion":"6.12.0","dist":{"shasum":"749aa053732f1ac336204fe6f657c176ef00a369","size":6100,"noattachment":false,"key":"/pg-types/-/pg-types-3.0.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-3.0.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_3.0.0_1573594728892_0.8979246574679514"},"_hasShrinkwrap":false,"publish_time":1573594729013,"_cnpm_publish_time":1573594729013},"2.2.0":{"name":"pg-types","version":"2.2.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec && npm run test-ts","test-ts":"if-node-version '>= 8' tsd"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"if-node-version":"^1.1.1","pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0","tsd":"^0.7.4"},"dependencies":{"pg-int8":"1.0.1","postgres-array":"~2.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.4","postgres-interval":"^1.1.0"},"engines":{"node":">=4"},"gitHead":"d9d9dfb87eb50914043cbc178c301b7dd3b0c50d","_id":"pg-types@2.2.0","_nodeVersion":"10.15.0","_npmVersion":"6.9.0","dist":{"shasum":"2d0250d636454f7cfa3b6ae0382fdfa8063254a3","size":10344,"noattachment":false,"key":"/pg-types/-/pg-types-2.2.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-2.2.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_2.2.0_1565140532940_0.6059651589271351"},"_hasShrinkwrap":false,"publish_time":1565140533099,"_cnpm_publish_time":1565140533099},"2.1.0":{"name":"pg-types","version":"2.1.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"pg-int8":"1.0.1","postgres-array":"~2.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.4","postgres-interval":"^1.1.0"},"engines":{"node":">=4"},"gitHead":"3c6d4b5647d857a470a84d3ebe72c2fd3452d90f","_id":"pg-types@2.1.0","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"shasum":"abdfa49153978a8f0ff55800897f29894aa739c0","size":9380,"noattachment":false,"key":"/pg-types/-/pg-types-2.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-2.1.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_2.1.0_1562358559948_0.2792547568314112"},"_hasShrinkwrap":false,"publish_time":1562358560039,"_cnpm_publish_time":1562358560039},"2.0.1":{"name":"pg-types","version":"2.0.1","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"pg-int8":"1.0.1","postgres-array":"~2.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.4","postgres-interval":"^1.1.0"},"engines":{"node":">=4"},"gitHead":"f46b3cea0455e966501ce3d68e5c4c5dcd3e853d","_id":"pg-types@2.0.1","_nodeVersion":"10.15.0","_npmVersion":"6.7.0","dist":{"shasum":"b8585a37f2a9c7b386747e44574799549e5f4933","size":8591,"noattachment":false,"key":"/pg-types/-/pg-types-2.0.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-2.0.1.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_2.0.1_1554388844854_0.5078895712564067"},"_hasShrinkwrap":false,"publish_time":1554388845065,"_cnpm_publish_time":1554388845065},"2.0.0":{"name":"pg-types","version":"2.0.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"pg-int8":"1.0.1","postgres-array":"~2.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"^1.1.0"},"engines":{"node":">=4"},"gitHead":"3281edf6a5dad0f46c5e78f8676a39d984a5f437","_id":"pg-types@2.0.0","_npmVersion":"6.4.1","_nodeVersion":"10.15.0","_npmUser":{"name":"bendrucker","email":"bvdrucker@gmail.com"},"dist":{"shasum":"038ddc302a0340efcdb46d0581cc7caa2303cbba","size":8592,"noattachment":false,"key":"/pg-types/-/pg-types-2.0.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-2.0.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types_2.0.0_1546982199859_0.19790152121134819"},"_hasShrinkwrap":false,"publish_time":1546982200074,"_cnpm_publish_time":1546982200074},"1.13.0":{"name":"pg-types","version":"1.13.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"pg-int8":"1.0.1","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"^1.1.0"},"gitHead":"593e56776c7e2ccbe0443a69d22aed2903a1e5dc","_id":"pg-types@1.13.0","_npmVersion":"5.5.1","_nodeVersion":"8.9.0","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"dist":{"shasum":"75f490b8a8abf75f1386ef5ec4455ecf6b345c63","size":8483,"noattachment":false,"key":"/pg-types/-/pg-types-1.13.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.13.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types-1.13.0.tgz_1510755123024_0.6702414255123585"},"directories":{},"publish_time":1510755123918,"_hasShrinkwrap":false,"_cnpm_publish_time":1510755123918},"1.12.1":{"name":"pg-types","version":"1.12.1","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"^1.1.0"},"gitHead":"f320a111e242716dde68f619fdef44969803f039","_id":"pg-types@1.12.1","_shasum":"d64087e3903b58ffaad279e7595c52208a14c3d2","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.11.2","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"dist":{"shasum":"d64087e3903b58ffaad279e7595c52208a14c3d2","size":8482,"noattachment":false,"key":"/pg-types/-/pg-types-1.12.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.12.1.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types-1.12.1.tgz_1503332099001_0.959631870733574"},"directories":{},"publish_time":1503332099958,"_hasShrinkwrap":false,"_cnpm_publish_time":1503332099958},"1.12.0":{"name":"pg-types","version":"1.12.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"ap":"~0.2.0","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"^1.1.0"},"gitHead":"e32e315b5d2bfcadbc1a449806ca69532ade83f3","_id":"pg-types@1.12.0","_shasum":"8ad3b7b897e3fd463e62de241ad5fc640b4a66f0","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.10.2","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"dist":{"shasum":"8ad3b7b897e3fd463e62de241ad5fc640b4a66f0","size":8465,"noattachment":false,"key":"/pg-types/-/pg-types-1.12.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.12.0.tgz"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-types-1.12.0.tgz_1495823854633_0.1996348628308624"},"directories":{},"publish_time":1495823855557,"_hasShrinkwrap":false,"_cnpm_publish_time":1495823855557},"1.11.0":{"name":"pg-types","version":"1.11.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"ap":"~0.2.0","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"~1.0.0"},"gitHead":"ed2d0e36e33217b34530727a98d20b325389e73a","_id":"pg-types@1.11.0","_shasum":"aae91a82d952b633bb88d006350a166daaf6ea90","_from":".","_npmVersion":"3.3.12","_nodeVersion":"5.5.0","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"aae91a82d952b633bb88d006350a166daaf6ea90","size":7756,"noattachment":false,"key":"/pg-types/-/pg-types-1.11.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.11.0.tgz"},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/pg-types-1.11.0.tgz_1461347783750_0.13011627295054495"},"directories":{},"publish_time":1461347786878,"_cnpm_publish_time":1461347786878,"_hasShrinkwrap":false},"1.10.0":{"name":"pg-types","version":"1.10.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"ap":"~0.2.0","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"~1.0.0"},"gitHead":"b29fd45313ce887f76e098bf69b4a588235be5e3","_id":"pg-types@1.10.0","_shasum":"7c66f5cea0accf4ece6cac3ccd07bbec6f474f1b","_from":".","_npmVersion":"2.7.4","_nodeVersion":"0.12.2","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"7c66f5cea0accf4ece6cac3ccd07bbec6f474f1b","size":7746,"noattachment":false,"key":"/pg-types/-/pg-types-1.10.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.10.0.tgz"},"directories":{},"publish_time":1438629106096,"_cnpm_publish_time":1438629106096,"_hasShrinkwrap":false},"1.9.0":{"name":"pg-types","version":"1.9.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"ap":"~0.2.0","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"~1.0.0"},"gitHead":"4cbcb893747aa31028d264662637dbda5fd29d67","_id":"pg-types@1.9.0","_shasum":"dfea2d096f905ae438a069b2dd8ac35a613d39e7","_from":".","_npmVersion":"2.7.4","_nodeVersion":"0.12.2","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"dfea2d096f905ae438a069b2dd8ac35a613d39e7","size":7741,"noattachment":false,"key":"/pg-types/-/pg-types-1.9.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.9.0.tgz"},"directories":{},"publish_time":1438263756046,"_cnpm_publish_time":1438263756046,"_hasShrinkwrap":false},"1.8.0":{"name":"pg-types","version":"1.8.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"tape test/*.js | tap-spec"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"pff":"^1.0.0","tap-spec":"^4.0.0","tape":"^4.0.0"},"dependencies":{"ap":"~0.2.0","postgres-array":"~1.0.0","postgres-bytea":"~1.0.0","postgres-date":"~1.0.0","postgres-interval":"~1.0.0"},"gitHead":"1ba33a8ee80fee9ac1cbe413a183924c2b98cfee","_id":"pg-types@1.8.0","_shasum":"7d8dde1a8175c552692962d6c185644484f80ac2","_from":".","_npmVersion":"2.7.4","_nodeVersion":"0.12.2","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"7d8dde1a8175c552692962d6c185644484f80ac2","size":7725,"noattachment":false,"key":"/pg-types/-/pg-types-1.8.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.8.0.tgz"},"directories":{},"publish_time":1438229858586,"_cnpm_publish_time":1438229858586,"_hasShrinkwrap":false},"1.7.0":{"name":"pg-types","version":"1.7.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"gitHead":"00f23a94ce09c4d747cd75bb3841db4526df3977","_id":"pg-types@1.7.0","_shasum":"de96a26e706067580d1eb1e644ed59bdd7332029","_from":".","_npmVersion":"2.0.0","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"de96a26e706067580d1eb1e644ed59bdd7332029","size":10696,"noattachment":false,"key":"/pg-types/-/pg-types-1.7.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.7.0.tgz"},"directories":{},"publish_time":1424534273587,"_cnpm_publish_time":1424534273587,"_hasShrinkwrap":false},"1.6.0":{"name":"pg-types","version":"1.6.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.6.0","_shasum":"3872a0f199143025497f4ee2a65fdaf00d7ea8b3","_from":".","_npmVersion":"1.4.9","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"3872a0f199143025497f4ee2a65fdaf00d7ea8b3","size":10217,"noattachment":false,"key":"/pg-types/-/pg-types-1.6.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.6.0.tgz"},"directories":{},"publish_time":1413401618127,"_cnpm_publish_time":1413401618127,"_hasShrinkwrap":false},"1.5.0":{"name":"pg-types","version":"1.5.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"gitHead":"f880b6f8b3816f6e4d4db08b26edc8f93844a867","_id":"pg-types@1.5.0","_shasum":"0a9d7146bac89bf447231e1c82fd526a5e730ab5","_from":".","_npmVersion":"1.4.26","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"0a9d7146bac89bf447231e1c82fd526a5e730ab5","size":10205,"noattachment":false,"key":"/pg-types/-/pg-types-1.5.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.5.0.tgz"},"directories":{},"publish_time":1412188443862,"_cnpm_publish_time":1412188443862,"_hasShrinkwrap":false},"1.4.0":{"name":"pg-types","version":"1.4.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.4.0","_shasum":"e10a13fe7a8ce3e0f23206e920af8615ce12eba1","_from":".","_npmVersion":"1.4.9","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"e10a13fe7a8ce3e0f23206e920af8615ce12eba1","size":9935,"noattachment":false,"key":"/pg-types/-/pg-types-1.4.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.4.0.tgz"},"directories":{},"publish_time":1405268848660,"_cnpm_publish_time":1405268848660,"_hasShrinkwrap":false},"1.3.0":{"name":"pg-types","version":"1.3.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.3.0","_shasum":"f3af9ccc6cb0838ec3cc31eac3442b15c2778489","_from":".","_npmVersion":"1.4.9","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"dist":{"shasum":"f3af9ccc6cb0838ec3cc31eac3442b15c2778489","size":9711,"noattachment":false,"key":"/pg-types/-/pg-types-1.3.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.3.0.tgz"},"directories":{},"publish_time":1401890126129,"_cnpm_publish_time":1401890126129,"_hasShrinkwrap":false},"1.2.0":{"name":"pg-types","version":"1.2.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.2.0","dist":{"shasum":"3579821b7a3d712d83551f4625ac9fd22d150ff0","size":9619,"noattachment":false,"key":"/pg-types/-/pg-types-1.2.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.2.0.tgz"},"_from":".","_npmVersion":"1.4.3","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"directories":{},"publish_time":1399902603137,"_cnpm_publish_time":1399902603137,"_hasShrinkwrap":false},"1.1.0":{"name":"pg-types","version":"1.1.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.1.0","dist":{"shasum":"5bedbebded1809bb7bbfd131f27ec28032f1ceb5","size":9489,"noattachment":false,"key":"/pg-types/-/pg-types-1.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.1.0.tgz"},"_from":".","_npmVersion":"1.4.3","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"directories":{},"publish_time":1399902088601,"_cnpm_publish_time":1399902088601,"_hasShrinkwrap":false},"1.0.0":{"name":"pg-types","version":"1.0.0","description":"Query result type converters for node-postgres","main":"index.js","scripts":{"test":"mocha"},"repository":{"type":"git","url":"git://github.com/brianc/node-pg-types.git"},"keywords":["postgres","PostgreSQL","pg"],"author":{"name":"Brian M. Carlson"},"license":"MIT","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"homepage":"https://github.com/brianc/node-pg-types","devDependencies":{"mocha":"^1.18.0"},"_id":"pg-types@1.0.0","dist":{"shasum":"0cc6fbc25b287d06691cf3e9a306b2198181f892","size":7730,"noattachment":false,"key":"/pg-types/-/pg-types-1.0.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/pg-types/download/pg-types-1.0.0.tgz"},"_from":".","_npmVersion":"1.4.3","_npmUser":{"name":"brianc","email":"brian.m.carlson@gmail.com"},"maintainers":[{"name":"bendrucker","email":"bvdrucker@gmail.com"},{"name":"brianc","email":"brian.m.carlson@gmail.com"}],"directories":{},"publish_time":1394915698912,"_cnpm_publish_time":1394915698912,"_hasShrinkwrap":false}},"readme":"# pg-types\n\nThis is the code that turns all the raw text from postgres into JavaScript types for [node-postgres](https://github.com/brianc/node-postgres.git)\n\n## use\n\nThis module is consumed and exported from the root `pg` object of node-postgres.  To access it, do the following:\n\n```js\nvar types = require('pg').types\n```\n\nGenerally what you'll want to do is override how a specific data-type is parsed and turned into a JavaScript type.  By default the PostgreSQL backend server returns everything as strings.  Every data type corresponds to a unique `OID` within the server, and these `OIDs` are sent back with the query response.  So, you need to match a particluar `OID` to a function you'd like to use to take the raw text input and produce a valid JavaScript object as a result. `null` values are never parsed.\n\nLet's do something I commonly like to do on projects: return 64-bit integers `(int8)` as JavaScript integers.  Because JavaScript doesn't have support for 64-bit integers node-postgres cannot confidently parse `int8` data type results as numbers because if you have a _huge_ number it will overflow and the result you'd get back from node-postgres would not be the result in the database.  That would be a __very bad thing__ so node-postgres just returns `int8` results as strings and leaves the parsing up to you.  Let's say that you know you don't and wont ever have numbers greater than `int4` in your database, but you're tired of receiving results from the `COUNT(*)` function as strings (because that function returns `int8`).  You would do this:\n\n```js\nvar types = require('pg').types\ntypes.setTypeParser(20, function(val) {\n  return parseInt(val, 10)\n})\n```\n\n__boom__: now you get numbers instead of strings.\n\nJust as another example -- not saying this is a good idea -- let's say you want to return all dates from your database as [moment](http://momentjs.com/docs/) objects.  Okay, do this:\n\n```js\nvar types = require('pg').types\nvar moment = require('moment')\nvar parseFn = function(val) {\n   return val === null ? null : moment(val)\n}\ntypes.setTypeParser(types.builtins.TIMESTAMPTZ, parseFn)\ntypes.setTypeParser(types.builtins.TIMESTAMP, parseFn)\n```\n_note: I've never done that with my dates, and I'm not 100% sure moment can parse all the date strings returned from postgres.  It's just an example!_\n\nIf you're thinking \"gee, this seems pretty handy, but how can I get a list of all the OIDs in the database and what they correspond to?!?!?!\" worry not:\n\n```bash\n$ psql -c \"select typname, oid, typarray from pg_type order by oid\"\n```\n\nIf you want to find out the OID of a specific type:\n\n```bash\n$ psql -c \"select typname, oid, typarray from pg_type where typname = 'daterange' order by oid\"\n```\n\n:smile:\n\n## license\n\nThe MIT License (MIT)\n\nCopyright (c) 2014 Brian M. Carlson\n\nPermission is hereby granted, free of charge, to any person obtaining a copy\nof this software and associated documentation files (the \"Software\"), to deal\nin the Software without restriction, including without limitation the rights\nto use, copy, modify, merge, publish, distribute, sublicense, and/or sell\ncopies of the Software, and to permit persons to whom the Software is\nfurnished to do so, subject to the following conditions:\n\nThe above copyright notice and this permission notice shall be included in\nall copies or substantial portions of the Software.\n\nTHE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR\nIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,\nFITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE\nAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER\nLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,\nOUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN\nTHE SOFTWARE.\n","_attachments":{},"homepage":"https://github.com/brianc/node-pg-types","bugs":{"url":"https://github.com/brianc/node-pg-types/issues"},"license":"MIT"}