13
14
15
16
17
18
19
20
21
22
23
24
|
# File 'lib/active_record/mti/connection_adapters/postgresql/adapter.rb', line 13
def column_definitions(table_name) exec_query(<<-SQL, 'SCHEMA').rows
SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '#{quote_table_name(table_name)}'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
AND a.attname != 'tableoid'
ORDER BY a.attnum
SQL
end
|