Advertisement
Guest User

Untitled

a guest
Jun 14th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. var pg = require('pg');
  2. var idpass = require('./idpass.js')
  3. var db_config = {
  4. user: idpass.user,
  5. password: idpass.password,
  6. database: 'test'
  7. }
  8. var query = 'CREATE TABLE items(id SERIAL PRIMARY KEY, text VARCHAR(40) not null, complete BOOLEAN)';
  9. pg.connect(db_config, function(err, client, done) {
  10. if(err) {
  11. return console.error('error connection', err);
  12. }
  13. client.query(query, function(err, result) {
  14. if(err) {
  15. return console.error('error insert', err);
  16. }
  17. });
  18. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement