How do I list all columns for a specified table?

Posted by Editorial Staff | Updated on

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:

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.

Related Questions & Answers