How do I create a table in postgres that's associated with a specific database?
Obviously from the command line one can do
Create table tablename ();But how do I make sure that the table is associated with the correct database?
CREATE table dbname.tablename();is giving me the error:
ERROR: schema "dbname" does not exist