title: Do I use the postgres 'default administrative connection database' to house my schema?
body: <p>We are attempting to convert our Oracle database to PostgreSQL (due to Oracle's ludicrous pricing model). The system is not in production yet but will soon so this needs to be done ASAP. Thank goodness we don't use that many Oracle database specific features and treat it mostly as a data store from out .NET applications in C#. As a replacement for OPD.Net we are looking at using the  <a href="http://www.npgsql.org/" rel="nofollow">Data Provider for PostgreSQL, Npgsql.NET</a>.</p>
  
  <p>Now I have installed PostgreSQL 9.5 on my Windows 2012 R2 server and want to create my first set of tables. I run PgAdmin III and login and am presented with a postgres 'default administrative connection database', now what?</p>
  
  <p>I have read <a href="https://wiki.postgresql.org/wiki/Database_Schema_Recommendations_for_an_Application" rel="nofollow">Database Schema Recommendations for an Application</a> but that page was last modified over 3 years ago and starts at the wrong point - for instance, do I use the postgres 'default administrative connection database' to house my schema? Or do I create another database? Is there a naming convention? I will probably use multiple schema's housed in one database but would appreciate any recommendations or best practices for creating PostgreSQL databases and schemas.</p>
  
  <p>Lastly, any pointers for converting from Oracle? I have read <a href="https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion" rel="nofollow">Oracle to PostgreSQL Conversion</a> but again, out of date - only considers Oracle 8. Anything that considers Oracle 12c? Anything that explains PostgreSQL in Oracle developer and DBA terms?</p>