In addition to the command line \d+
you already found, you could also use the Information Schema to look up the column data, using information_schema.columns:
1 2 3 4 5 | SELECT * FROM information_schema.columns 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.