schema 8.1.5

From: km <km(at)mrna(dot)tn(dot)nic(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: schema 8.1.5
Date: 2006-10-26 21:04:51
Message-ID: 20061026210451.GA18304@mrna.tn.nic.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2006-10-26 21:10:31 Re: schema 8.1.5
Previous Message Tom Lane 2006-10-26 20:41:30 Re: Effect of large text field data on queries