Came across gdesc psql command.

Can come handy if one needs is to check what column datatypes they use/returned:

db=> select * from companies `\gdesc`
   Column    |           Type
-------------+--------------------------
 id          | uuid
 name        | character varying(255)
 external_id | character varying(255)
 customer_id | uuid
 provider_id | uuid
 redirect    | text
 created_at  | timestamp with time zone
 updated_at  | timestamp with time zone