如何从SQL查询中获取列的属性（PHP \ Phalcon \ PostgreSQL）

Question

I have two tables: manager, order.

One manager has many orders.

How i can get columns types, which in SELECT, from query like this

SELECT m.name, o.date, o.phone
FROM manager m
LEFT JOIN order o ON m.id = o.manager_id

Answer 1

Postgresql 9.4

SELECT column_name , data_type ,character_maximum_length  FROM information_schema.columns WHERE table_schema = 'your_schema' AND table_name   = 'your_table';