使用Typeorm从Postgres数据库返回ROW_NUMBER()

import { createConnection, getConnection } from "typeorm";

async function getRowsWithRowNumber() {
  const connection = await createConnection({
    type: "postgres",
    host: "your_host",
    port: 5432,
    username: "your_username",
    password: "your_password",
    database: "your_database",
    entities: [/* your entity classes */],
    synchronize: true,
  });

  const query = `
    SELECT ROW_NUMBER() OVER (ORDER BY id) AS row_number, *
    FROM your_table
  `;

  const rows = await getConnection().query(query);

  await connection.close();

  return rows;
}

getRowsWithRowNumber().then((rows) => {
  console.log(rows);
}).catch((error) => {
  console.error(error);
});