get-schema

0.1.11 • Public • Published

get-schema

Get Redshift / postgres schema for a table

Install

npm install get-schema

Usage

pg        = require('pg')
conString = 'postgres://postgres:1234@localhost/postgres'
GetSchema = require('get-schema')
 
pg.connect(conString, function(err, client, done) {
  if(err) throw new Error(err)
 
  schema = new GetSchema(client) // valid client that supports 'query()'
  schema.getColumns('registered_voters', function(err, result) {
      // results: [ "id", "timestamp", "name", "voted" ]
  })
  schema.get('registered_voters', function(err, result) {
    // results: 
    // [ { id: 'integer' },
    // { timestamp: 'timestamp' },
    // { name: 'varchar' },
    // { voted: 'boolean' }
  })
  schema.getCreateTypes('registered_voters', function(err, result) {
    // results: 
    // [ { id: 'integer' },
    // { timestamp: 'timestamp' },
    // { name: 'varchar(80)' }, // character length added
    // { voted: 'boolean' }
  })
})

License

MIT

Readme

Keywords

none

Package Sidebar

Install

npm i get-schema

Weekly Downloads

1

Version

0.1.11

License

none

Last publish

Collaborators

  • angleman