In addition to the command line
\d+ you already found, you could also use the Information Schema to look up the column data, using
WHERE table_schema = 'your_schema'
AND table_name = 'your_table'
Note: As per the example above, make sure the values are enclosed within quotes.
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.