title: How to check for column attributes in postgreSQL?
body: <p>I am new to SQL. Let say that when someone created a table like this in database named test1 of PostgreSQL:</p>
  <pre><code>CREATE TABLE users (
      id SERIAL PRIMARY KEY,
      created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME,
      updated_at TIMESTAMP DEFAULT CURRENT_TIME,
      contents VARCHAR(240) NOT NULL);
  </code></pre>
  <p>I make a query to the database and do not know how data in columns are stored.
  Is there a query to return the stored definition of the columns in the users table or a method to check this ?</p>
  <p>For example:
  The result should return something like:</p>
  <pre><code>id column: SERIAL PRIMARY KEY
  created_at: TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIME
  ...
  </code></pre>