title: SELECT ALL column_names in postgresql
body: <p>I'm using <code>PostgreSQL</code> and I want to create a <code>query</code> that will display all <code>column_names</code> in a specific <code>table</code>.</p>
  
  <pre><code>Schema: codes
  
  Table Name: watch_list
  </code></pre>
  
  <p>Here are the <code>column_names</code> in my <code>table</code>:</p>
  
  <pre><code>watch_list_id, watch_name, watch_description
  </code></pre>
  
  <p>I tried what I found in the web:</p>
  
  <pre><code>SELECT *
  FROM information_schema.columns
  WHERE table_schema = 'codes'
    AND table_name   = 'watch_list'
  </code></pre>
  
  <p>It output is not what I wanted. It should be:</p>
  
  <pre><code>watch_list_id, watch_name, watch_description
  </code></pre>
  
  <p>How to do this?</p>