PostgreSQL find column data type | The Dev Tool |

To find the column data type of a table you can select from the information_schema.columns table. In many instances, PostgreSQL keeps the data about your schema in a normal table you can just select from.

Run the following query and just replace MYCOLUMN with your column.

SELECT column_name, data_type FROM information_schema.columns WHERE TABLE_NAME = 'MYCOLUMN';

Created by: martin


This page is only partially working without JavaScript. It will show content, but the tools and interactivity cannot be shown without JavaScript enabled. Please enable JavaScript for this page. About Us