schema 8.1.5 - Mailing list pgsql-general

From km
Subject schema 8.1.5
Date
Msg-id 20061026210451.GA18304@mrna.tn.nic.in
Whole thread Raw
Responses Re: schema 8.1.5  (Alan Hodgson <ahodgson@simkin.ca>)
Re: schema 8.1.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi all,

Have a general doubt abt default  schema public  in postgresql 8.1.5:

i would like to know if for every database a valid user creates, postgreSQL by default creates a public schema which is
optional?  

Also is it possible to know which schema i am currently in ?

how do i  set a user account to default to a predefined schema  ?

i have tried :
SET search_path TO myschema;
but thats temprary setting i suppose.

so that when the user logis in and accesses a database via psql he should be able to land into his schema. how do i do
that? any tips ? 

regards,
KM


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Effect of large text field data on queries
Next
From: Alan Hodgson
Date:
Subject: Re: schema 8.1.5