Re: Server/Database/Schema Definitions

On Tue, May 16, 2006 at 09:23:09AM -0500, Brandon E Hofmann wrote:
>
> 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?

You can do that, yes. You can also change search_path; any object not
created in a specific schema will go into the first schema listed in
search_path.

You can set a default tablespace in postgresql.conf, at the database
level, and I think at the session level as well.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461