title: How can I export the schema of a database in PostgreSQL?
body: <p>My computer broke down but fortunately I backed up 
  the folder C:\Program Files\PostgreSQL.</p>
  
  <p>Now I'm working in a new computer and I would like to import the previous
  Postgres databases that are stored in the external disk.</p>
  
  <p>I would like to export the schema of a specific database
  that is located in the backup folder.</p>
  
  <p>The file <code>PostgreSQL\8.3\data\global\pg_database</code> contains information
  about databases and their OIDs; for example:</p>
  
  <pre><code>"db1" 20012
  "db2" 23456
  </code></pre>
  
  <p>I would like to export the schema of "db1".</p>
  
  <p>There is a folder named "20012" in folder <code>"PostgreSQL\8.3\data\base\20012"</code>
  that contains a lot of files [500 files].</p>
  
  <p>Is there any way to export the schema of that database?</p>
  
  <p>Note that all of the Postgresql database files are located 
  in an external hard disk and I would like to export the schema of that database in an SQL file, take that file, run it and create the same exact database locally.</p>