title: Postgresql - Create Database & Table dynamically
body: <p>This code is not working. Can anyone direct me where I can find examples of creating a Postgresql database and table on the fly with C#?</p>
  
  <pre><code>     const string connStr = "Server=localhost;Port=5432;
                            User Id=postgres;Password=enter;Database=postgres";
  
          var m_conn = new NpgsqlConnection(connStr);
  
          // creating a database in Postgresql
          m_createdb_cmd = new NpgsqlCommand("CREATE DATABASE IF NOT EXISTS  \"testDb\" " +
                                         "WITH OWNER = \"postgres\" " +
                                         "ENCODING = 'UTF8' " +
                                         "CONNECTION LIMIT = -1;", m_conn);
  
          // creating a table in Postgresql
          m_createtbl_cmd = new NpgsqlCommand(
              "CREATE TABLE MyTable(CompanyName VARCHAR(150))";
  
          m_conn.Open();
          m_createdb_cmd.ExecuteNonQuery();
          m_createtbl_cmd.Connection = m_conn;
          m_conn.Close();
  </code></pre>
  
  <p>The db is created but I get a silent fail on creating the table.</p>