openpolitics.com

7 More Useful SQL and/or Postgres Techniques

6) Get column names for a table

<span class="k">select</span> <span class="k">column_name</span>
<span class="k">from</span> <span class="n">information_schema</span><span class="p">.</span><span class="n">columns</span>
<span class="k">where</span> <span class="k">table_name</span><span class="o">=</span><span class="s1">'items'</span>