Potgresql

UPDATE:2023-06-13

On this page

ODBC

  1. Driver install
  2. DSN Setting
    Windows : ODBC data source administrator

Method

    Postgresql system tables have OIDs instead of table IDs, but the use of OIDs is deprecated, so use sequential numbers instead.
  1. [System]Get TableName
    SELECT "tablename","schemaname" FROM "pg_tables"
  2. [System]Get FieldName and FieldType
    SELECT "ordinal_position","column_name","data_type"
    　FROM information_schema.columns
    　　WHERE table_schema ='<Schema Name>' AND table_name= '<Table Name>'
    　　　ORDER BY ordinal_position