SEO

#1 (**permalink**) 04-09-2008, 12:03 PM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-09-2008, 12:03 PM

On Thursday 26 October 2006 14:04, km <km@mrna.tn.nic.in> wrote:
>> 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 ?

alter role rolename set search_path=path1[,path2...];

--
Ginsberg's Theorem:
1) You can't win.
2) You can't break even.
3) You can't quit the game.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-09-2008, 12:03 PM

km <km@mrna.tn.nic.in> writes:
> how do i set a user account to default to a predefined schema ?

If you make the choice user name = schema name, this happens for free.
See
http://www.postgresql.org/docs/8.1/s...l-schemas.html
The bit about common usage patterns might help in particular.

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

Doesn't have to be. See postgresql.conf and ALTER USER.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

schema 8.1.5