Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

    pg2jsonpublic

    Promises/A+ logo

    pg2json

    This module loads postgres meta data and returns it as json.

    Build Status

    Usage

    CLI

    1. create a config file:
    {
        "charset": "utf8",
        "database": "heinzel",
        "host": "127.0.0.1",
        "user": "user",
        "password": "password"
    }
    1. use the cli
    node bin\cli.js -c configFile -o outputFile
    

    use help (-h / -help) for more information 3. select desired table

    Node module


    var pg2json = require('pg2json');
     
    //1. Setup connection
    pg2json.connect({
        charset: 'utf8',
        database: 'test',
        host: '127.0.0.1',
        user: 'user',
        password: 'password'
    });
     
    //2. Get tables
    pg2json.getTables()
        .then(onTablesRead)
        .fail(onError);
     
    //3. Get columns
    pg2json.getColumns('tableName')
        .then(onColumnsRead)
        .fail(onError);
     
    //4. Get relations
    pg2json.getRelations('tableName')
        .then(onRelationsRead)
        .fail(onError);

    Keywords

    none

    install

    npm i pg2json

    Downloadsweekly downloads

    3

    version

    1.0.0

    license

    MIT

    repository

    githubgithub

    last publish

    collaborators

    • avatar