GeezerVison is showing github.com — Databases/JavaScript/application.js at master · HowProgrammingWorks/Databases

Expand file tree

application.js

Copy path

More file actions

22 lines (18 loc) · 433 Bytes

Copy path

22 lines (18 loc) · 433 Bytes

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

'use strict';

const db = require('./db.js');

const pg = db.open({

host: '127.0.0.1',

port: 5432,

database: 'application',

user: 'marcus',

password: 'marcus',

});

console.dir({ pg });

pg.select('pg_tables')

.where({ tableowner: 'marcus', schemaname: 'public' })

.fields(['schemaname', 'tablename', 'tableowner', 'hasindexes'])

.order('tablename')

.then((rows) => {

console.table(rows);

pg.close();

});