获取表结构

Oracle 获取表结构

	SELECT
		b.TABLE_NAME AS tableName,
		a.column_name AS columnName,
		a.data_type  AS columnType,
		 a.data_length dataLength,
		a.nullable AS 是否为空 
	FROM
		user_tab_columns a,
		user_col_comments b 
	WHERE
		a.TABLE_NAME = ‘table_name’
		AND b.table_name = ‘table_name’
		AND a.column_name = b.column_name

Postgre 获取表结构

	SELECT 
		A.attnum AS "序号",
		C.relname AS "表名",
		A.attname AS "列名",
		concat_ws ( '', T.typname, SUBSTRING ( format_type ( A.atttypid, A.atttypmod ) FROM '\(.*\)' ) ) AS "字段类型",
		d.description AS "备注" 
	FROM
		pg_class C,
		pg_attribute A,
		pg_type T,
		pg_description d 
	WHERE
		C.relname = 'table_name' 
		AND A.attnum > 0 
		AND A.attrelid = C.oid 
		AND A.atttypid = T.oid 
		AND d.objoid = A.attrelid 
		AND d.objsubid = A.attnum 
	ORDER BY
		C.relname DESC,
		A.attnum ASC