create-table.js 397 B

12345678910111213141516171819202122232425
  1. const { Client } = require('pg')
  2. const client = new Client({
  3. user: 'postgres',
  4. host: 'localhost',
  5. database: 'testdb',
  6. password: '1234abcd',
  7. port: 5432,
  8. });
  9. client.connect()
  10. const query = `
  11. CREATE TABLE users (
  12. email varchar,
  13. firstName varchar,
  14. lastName varchar,
  15. age int
  16. );
  17. `
  18. client.query(query, (err, res) => {
  19. console.log(err, res)
  20. client.end()
  21. });