get datatype for postgres

1. select column_name, data_type from information_schema.columns
-# where table_name = 'config';

2.SELECT pg_typeof("stu_id"), pg_typeof(100) from student_details limit 1;

3.运行psql -E，然后\d student_details