title: Description of PostgreSQL database tables installed on a particular computer
body: <p>A bit over a year ago I installed PostgreSQL on six computers. On one of those computers, I imported 2 gig of census data from CSV files. </p>
  
  <p>Historically I have just worked with flat files, but in this case the files are so big they choke my analysis software.  I am new to both PostgreSQL and relational databases in general, and I have a very basic beginner's question: What software (e.g. pgAdmin III) and what and  commands would I use to quickly answer the following questions on each machine:</p>
  
  <ol>
  <li><p>Is PostgreSQL in still installed and running on each machine?</p></li>
  <li><p>(If 1 is yes) Does the machine in question have installed any non-bundled tables or data?</p></li>
  <li><p>(If 2 is yes) How can I produce a summary description of the tables that are installed?</p></li>
  </ol>
  
  <p>In terms of a summary description, I am hoping for the table name, a list of column names, the data type of each, and the number of lines or records in each table, and possibly any additional database-relevant facts like whether the column is a key or indexed.</p>
  
  <p>I work mainly under Windows 7 &amp; 8, though I have a virtual Ubuntu macine installed on one computer.</p>