title: Does creating a unique constraint also create an index in Postgres?
body: <p>I'm cleaning up some unused indexes on some tables.  Before removing them I'm looking up to see how they were created. Some of them looks like they were added when the table was created by adding a <code>constraint somename unique</code> int the sql script. It makes me think there are multiple ways to create an index. Does creating a table like this create an index automatically?</p>
  
  <pre><code>(
      id serial not null,
      name text not null,
      other_name text not null,
      constraint constraint_or_index
          unique (name, other_name)
  );
  </code></pre>