/*************************************************** 
 POSTGRESQL 
 Desc[ribe] table
 List columns, datatype and other info 
***************************************************/
 
SELECT column_name, data_type, character_maximum_length AS length, is_nullable, column_default 
FROM   information_schema.columns
WHERE  table_name = 'student'                      -- must be lowercase
ORDER BY ordinal_position;


SELECT *                            # List all column info 
FROM   information_schema.COLUMNS   
WHERE  table_name = 'student'