neon_serverless_postgres_connection_and_version_query.ts

1import { neon } from '@neondatabase/serverless';
2import * as dotenv from 'dotenv';
3
4// Load environment variables from .env file
5dotenv.config();
6
7async function getPgVersion() {
8  // Initialize the connection using the DATABASE_URL environment variable
9  const sql = neon(process.env.DATABASE_URL!);
10
11  // Execute a simple query
12  const result = await sql`SELECT version()`;
13  
14  // Output the result
15  console.log(result[0].version);
16}
17
18getPgVersion();