title: Postgres and Indexes on Foreign Keys and Primary Keys
body: <p>Does Postgres automatically put indexes on Foreign Keys and Primary Keys?  How can I tell?  Is there a command that will return all indexes on a table?</p>