title: Is there a psql command to show table definitions?
body: <p>The <a href="http://www.sqlite.org/cli.html" rel="nofollow noreferrer">sqlite3</a> CLI has a command <code>.schema</code> that will display the columns of all tables in the database.</p>
  
  <p>The <a href="http://http://www.postgresql.org/docs/9.3/static/app-psql.html" rel="nofollow noreferrer">psql</a> CLI for PostgreSQL has a meta-commands <code>\d</code> that shows columns for all "relations" (table, view, index, sequence, or foreign table) and a meta-command <code>\dt</code> that lists the relations that are tables but does not show the columns of those tables.</p>
  
  <p>Is there a way to get <code>psql</code> to show output like sqlite3's <code>.schema</code> - show the output of <code>\d</code> on just relations that are tables?  <code>\d *</code> shows columns for all relations, which in my database of 32 tables contains 63 tables and sequences.  The pattern (<code>*</code> in this example) seems able to match on relation name but not relation type.  Is there a pattern for "match all tables"?</p>