Two causes:
1) I have to rewrite many lines of code = time
2) In MySQL I have access - with superuser rights - to _all_ existing
databases inside the installation. In Postgres I haven't.
But, of course, that are just details.
Best,
Andi
Tom Lane schrieb:
Andreas Kalsch <andreaskalsch@xxxxxx> writes:
This is what I want to do: To refer to another database, like I can do
it in MySQL.
You're too hung up on the word "database". MySQL "databases" are very
nearly equivalent to Postgres schemas. Use multiple schemas within
one Postgres database and be happy.
- I have to reset the search_path very often. This is probably not very
elegant, but will be my solution then ...
And in MySQL you do "use foo" often. What's the difference?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
