title: how to change default public schema on the psql command line
body: <p>In order to load a MS Access mdb file into PostgreSQL, I type the following command on the psql command line.</p>
  
  <pre><code>mdb-schema xxx.mdb postgres | psql -h xxx -U xxx -W -d xxx
  </code></pre>
  
  <p>However, the Postgres tables are made under the default public schema. I want to have them under a different schema ("network"), rather than the default schema("public"). Could you please tell me how to change from "public" to "network" in this situation?</p>
  
  <p>I appreciate any suggestions.</p>