表结构
1、导出mysql的表结构
SELECT
table_schema,
table_name,
ordinal_position,
COLUMN_NAME,
COLUMN_TYPE,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH,
IS_NULLABLE,
COLUMN_KEY,
COLUMN_DEFAULT,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'database' --数据库名称
AND table_name = 'table_name' --表名称
order by table_name, ordinal_position
2、导出postgreSQL的表结构
SELECT
'pgcloud' scheme,
c.relname,
a.attnum,
a.attname AS field,
t.typname AS type,
a.attlen AS length,
a.atttypmod AS lengthvar,
a.attnotnull AS notnull,
b.description AS comment
FROM pg_class c,
pg_attribute a
LEFT OUTER JOIN pg_description b ON a.attrelid=b.objoid AND a.attnum = b.objsubid,
pg_type t
WHERE c.relname in ( SELECT tablename FROM pg_tables where schemaname = 'public')
and a.attnum > 0
and a.attrelid = c.oid
and a.atttypid = t.oid
ORDER BY c.relname, a.attnum;