How to get a list column names and datatypes of a table in PostgreSQL?
SELECT column_name, data_typeFROM information_schema.columnsWHERE table_name = 'table_name';
with the above query you can columns and its datatype
SELECT a.attname as "Column", pg_catalog.format_type(a.atttypid, a.atttypmod) as "Datatype" FROM pg_catalog.pg_attribute a WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = ( SELECT c.oid FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relname ~ '^(hello world)$' AND pg_catalog.pg_table_is_visible(c.oid) );
More info on it : http://www.postgresql.org/docs/9.3/static/catalog-pg-attribute.html