SQL statement--get database table information, table name, column name, description comment, etc.

information_schemaDetails

import pandas as pdimport reimport psycopg2from sqlalchemy import create_engine# Link library account informationgongsi_engine = psycopg2.connect(dbname='kk_dw',user='*******',password='*****',host='***')# Read the required data table from the company databasetable_data = pd.read_sql(r"select * from pg_tables where schemaname = 'dwd';",con=gongsi_engine)table_data.head()data = pd.read_sql(r"""select *from information_schema.columnswhere table_schema='dwd'and table_name='dwd_store_other_in_storage_orders_detail'""",con=gongsi_engine)data[['table_name','column_name','udt_name']]

Get a description, etc.

data = pd.read_sql(r"""selecta.attnum,n.nspname,c.relname,a.attname as field,t.typname as type,a.attlen as length,a.atttypmod as lengthvar,a.attnotnull as notnull,b.description as commentfrompg_namespace n left join pg_class con n.oid = c.relnamespaceleft join pg_attribute aon a.attrelid = c.oidleft join pg_description bon a.attrelid = b.objoid and a.attnum = b.objsubidleft join pg_type ton a.atttypid = t.oidwheren.nspname = 'dwd' --table_schemaand c.relname = 'dwd_store_o2o_sales_detail' -- table_nameand a.attnum > 0order bya.attnum;""",con=gongsi_engine)

The function implemented in this way is that I can obtain information such as table names, fields and field descriptions in the database in batches.