主页 / dba / 问题 / 57130
Accepted
oxfist
Asked: 2014-01-21 04:45:15 +0800 CST

如何按排序顺序列出所有表列？

  • 772

我知道\d table_name列出了该表的所有列，但是有没有办法按字母顺序列出它们？

postgresql table

2 个回答

  1. Best Answer

    通常，使用information_schema：

    SELECT column_name
FROM information_schema.columns 
WHERE table_schema = 'public' 
AND table_name = 'blah' 
ORDER BY column_name ASC;
    • 27

  2. 这也有效：

    SELECT col_attr.attname as "ColumnName" 
FROM pg_catalog.pg_attribute col_attr 
WHERE col_attr.attnum > 0 
AND NOT col_attr.attisdropped 
AND col_attr.attrelid = 
(SELECT cls.oid 
FROM pg_catalog.pg_class cls 
LEFT JOIN pg_catalog.pg_namespace ns 
ON ns.oid = cls.relnamespace 
WHERE cls.relname = 'MyTable') 
ORDER BY "ColumnName" ASC
    • 0

相关问题