Are you saying you have to reconnect to change schemas? In Oracle and
PostgreSQL both you can change the current schema (or schemas for
postgresql) with a single inline command.
No I meant you have to change the schema after connecting.
Some hosts only give you one db & one user. Yeh it sucks but that's all
they give you.
Before anyone says "get a new host".. from the end user POV.. you don't
know and/or don't care about the technical details, you just want
something "that works" with what you have. It's not an ideal situation
to be in but it definitely does happen.
Shared hosts don't give you a lot of resources, so apps build stuff like
that in to make it easier.
Schemas cost virtually nothing.
Neither does building a smart(er) app which lets you set a "prefix" for
all of your tables so they are grouped together.
You'll get a tiny performance hit from doing the replacement of the
prefix, but it's not going to be significant compared to everything else.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
