Search Postgresql Archives

Server/Database/Schema Definitions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



When coding table and function scripts, how do you specify which
server/database/schema where you want new tables and functions to reside?
Every time I execute my creation scripts, it puts everything in the public
schema under the PostgreSQL server.  I'm new to PostgreSQL and haven't
found any documentation discussing these characteristics.

Do you explicitly define the server.schema.table_name in the create table
statement?  Should the tablespace be set to pg_default and the owner to
postgres?

Any help you could provide would be greatly appreciated.

Thanks,

Brandon



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux