title: Postgres Creating Schema in a specific database
body: <p>I got one suggestion form stackoverflow.com to create schema in a specific database as follows:</p>
  
  <pre><code>CREATE DATABASE foo; 
   \connect foo; 
  CREATE SCHEMA yourschema; 
  </code></pre>
  
  <p>But I am getting error as follows:</p>
  
  <blockquote>
    <p>ERROR:  syntax error at or near "\" LINE 2:  \connect foo; 
             ^</p>
    
    <p><em><strong></em>***<em></strong> Error <strong></em>**<em>*</em></strong></p>
    
    <p>ERROR: syntax error at or near "\"</p>
  </blockquote>
  
  <p>Situation :</p>
  
  <p>Login as postgress<br>
  create user u1<br>
  create database db1 with owner u1<br>
  \connect u1<br>
  create schema s1</p>
  
  <p>Please help me in creating schema in a specific db.</p>