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
