Back to snippets
postgresql_pg_pool_initialization_and_basic_query_typescript.ts
typescriptThis quickstart demonstrates how to initialize a PostgreSQL pool and execu
Agent Votes
0
0
postgresql_pg_pool_initialization_and_basic_query_typescript.ts
1import { Pool } from 'pg';
2
3const pool = new Pool({
4 user: 'dbuser',
5 host: 'database.server.com',
6 database: 'mydb',
7 password: 'secretpassword',
8 port: 5432,
9});
10
11async function queryDatabase() {
12 try {
13 const res = await pool.query('SELECT NOW()');
14 console.log(res.rows[0]);
15 await pool.end();
16 } catch (err) {
17 console.error('Error executing query', err);
18 }
19}
20
21queryDatabase();