I am just starting with postgresql.
I have successfully made connection with cloud database and retrieved data using nodejs ‘postgres’ package, but the program doesn’t end after it logs all the data on console, it’s still running. Why is that?
<code>import postgres from 'postgres'
import "dotenv/config"
const sql = postgres({
host: process.env.DATABASE_HOST,
database: process.env.DATABASE_NAME,
username: process.env.DATABASE_USER,
password: process.env.DATABASE_PASSWORD,
ssl: 'require',
})
async function getInfo() {
const users = await sql`
select * from information_schema.tables
`
return users
}
getInfo().then((data) => console.log(data))
</code>
<code>import postgres from 'postgres'
import "dotenv/config"
const sql = postgres({
host: process.env.DATABASE_HOST,
database: process.env.DATABASE_NAME,
username: process.env.DATABASE_USER,
password: process.env.DATABASE_PASSWORD,
ssl: 'require',
})
async function getInfo() {
const users = await sql`
select * from information_schema.tables
`
return users
}
getInfo().then((data) => console.log(data))
</code>
import postgres from 'postgres'
import "dotenv/config"
const sql = postgres({
host: process.env.DATABASE_HOST,
database: process.env.DATABASE_NAME,
username: process.env.DATABASE_USER,
password: process.env.DATABASE_PASSWORD,
ssl: 'require',
})
async function getInfo() {
const users = await sql`
select * from information_schema.tables
`
return users
}
getInfo().then((data) => console.log(data))