38460-vm/backend/check_tables.js
2026-02-16 01:14:10 +00:00

27 lines
616 B
JavaScript

const { Sequelize } = require('sequelize');
require('dotenv').config();
const sequelize = new Sequelize(
'app_38100',
process.env.DB_USER,
process.env.DB_PASS,
{
host: process.env.DB_HOST,
port: process.env.DB_PORT,
dialect: 'postgres',
logging: false,
}
);
async function check() {
try {
const [results, metadata] = await sequelize.query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'");
console.log('Tables in app_38100:', results);
} catch (err) {
console.error('Error:', err);
} finally {
await sequelize.close();
}
}
check();