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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
