I am using pg library to make query on postgres by typeScript. I have created a db class like this:
import { Pool } from 'pg';
const pool = new Pool({
host: process.env.PG_HOST,
port: parseInt(process.env.PG_PORT),
user: process.env.PG_USER,
password: process.env.PG_PASSWORD,
database: process.env.PG_DATABASE,
idleTimeoutMillis: 30000,
ssl: true
});
export default pool;
Now In my class When I am trying to select a query:
const result = await pool.query('SELECT email FROM User LIMIT 10');
I got :
stack:'error: column "email" does not exist\n at Parser.parseErrorMessage ... at TLSSocket.emit (node:events:526:28)\n at addChunk (node:internal/streams/readable:315:12)\n at readableAddChunk (node:internal/streams/readable:289:9)\n at TLSSocket.Readable.push (node:internal/streams/readable:228:10)\n at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23)\n at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17)'
But I have an email column In the user Table:
CodePudding user response:
Try the following as your query:
SELECT email FROM "User" LIMIT 10
You need to quote the table name if you did it when creating the table.