テーブル一覧を取得
SELECT relname AS table_name FROM pg_stat_user_tables
カラム名一覧を取得
SELECT * FROM pg_attribute WHERE attrelid = 'your_table_name'::regclass;
参考URL
http://chopl.in/post/2013/11/07/how_to_retrieve_tables_and_columns_with_postgres/
SELECT relname AS table_name FROM pg_stat_user_tables
SELECT * FROM pg_attribute WHERE attrelid = 'your_table_name'::regclass;
http://chopl.in/post/2013/11/07/how_to_retrieve_tables_and_columns_with_postgres/