Method tableSchema

src/drivers/postgres/postgres-driver.ts:291–389

(
    schemaName: string,
    tableName: string
  )

  }

  async tableSchema(
    schemaName: string,
    tableName: string
  ): Promise<DatabaseTableSchema> {
    const columnsResult = (
      await this.query(
        `SELECT * FROM information_schema.columns WHERE  table_schema = ${this.escapeValue(schemaName)} AND table_name = ${this.escapeValue(tableName)}`
      )
    ).rows as unknown as PostgresColumnRow[];

    const constraintResult = (
      await this.query(`SELECT
	tc.constraint_name,
	tc.table_schema,
	tc.table_name,
	tc.constraint_type,
	kcu.column_name,
	ccu.table_schema AS reference_table_schema,
	ccu.table_name AS reference_table_name,
	ccu.column_name AS reference_column_name
FROM
	information_schema.table_constraints AS tc
	LEFT JOIN information_schema.key_column_usage AS kcu
	ON (
		tc.table_schema = kcu.table_schema AND
		tc.table_name = kcu.table_name AND
		tc.constraint_name = kcu.constraint_name
	)
	LEFT JOIN information_schema.constraint_column_usage AS ccu
	ON (
		ccu.table_schema = kcu.table_schema AND
		ccu.constraint_name = kcu.constraint_name
	)
WHERE
	tc.table_schema = ${this.escapeValue(schemaName)} AND tc.table_name = ${this.escapeValue(tableName)}`)
    ).rows as unknown as PostgresConstraintRow[];

    const constraintRecord: Record<string, DatabaseTableColumnConstraint> = {};
    for (const constraint of constraintResult.filter(
      (f) => f.column_name !== null
    )) {
      const key = constraint.constraint_name;
      const constraintItem = constraintRecord[key] || {
        name: constraint.constraint_name,
        primaryKey: false,
        notNull: false,
        unique: false,
        checkExpression: "",
        defaultValue: null,
      };

      if (constraint.constraint_type === "PRIMARY KEY") {
        constraintItem.primaryKey = true;
        constraintItem.primaryColumns = [
          ...(constraintItem?.primaryColumns ?? []),
          constraint.column_name,
        ];
      } else if (constraint.constraint_type === "FOREIGN KEY") {