通过原生sql获取tables的schema信息

tables

• SELECT * FROM information_schema.tables WHERE table_schema='titanhouse_schema';
• SELECT * FROM pg_tables

columns

• SELECT * FROM information_schema.columns WHERE table_schema='titanhouse_schema';

constraints

• SELECT * FROM information_schema.table_constraints WHERE constraint_schema='titanhouse_schema';
• SELECT * FROM information_schema.key_column_usage WHERE constraint_schema='titanhouse_schema';
• SELECT * FROM information_schema.constraint_column_usage WHERE constraint_schema='titanhouse_schema';
• SELECT * FROM information_schema.check_constraints WHERE constraint_schema='titanhouse_schema';

triggers

• SELECT * FROM information_schema.triggers WHERE trigger_schema='titanhouse_schema';

参考

• https://www.postgresql.org/docs/current/information-schema.html
  • 每个字段含义
• https://stackoverflow.com/questions/58431104/difference-between-information-schema-tables-and-pg-tables
• https://stackoverflow.com/questions/2276644/list-all-tables-in-postgresql-information-schema
• https://stackoverflow.com/questions/14730228/postgresql-query-to-list-all-table-names/38768811
• https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql
• https://dba.stackexchange.com/questions/22362/how-do-i-list-all-columns-for-a-specified-table
• https://dba.stackexchange.com/questions/214863/how-to-list-all-constraints-of-a-table-in-postgresql