Shridhar,
Thanks again for the info, this is exactly what I needed.
I apologize for not replying to all; I usually do, but I'm out of practice
with this list. :)
Thanks,
Peter Darley
-----Original Message-----
From: Shridhar Daithankar [mailto:shridhar@frodo.hserus.net]
Sent: Wednesday, February 04, 2004 12:19 AM
To: Peter Darley; Pgsql-General
Subject: Re: [GENERAL] Transfer database tables to a schema
Peter Darley wrote:
> I don't have large objects or schemas in the db I want to move, but I do
> have languages and functions. I'm not sure if I need to be worried about
> collisions there or not. I can't tell weather languages/functions live in
> the database, or in a schema of the database.
Functions are dumped. They are specific to schemas as well. There could be
two
functions with same name/signature in different schemas and that is
perfectly
fine. That's where your schema search path comes into picture. Set it right
and
everything will be in the right cell.
As goes for languages, I am not sure if they are dumped. However you can
create
them manually if required. There are hardly few dozens of them out
there..:-)
But adding language is only required if source database had it but not the
target database. If two databases are failrly similar, then it should not be
needed.
<OT>
I request you to make a habit to reply all, while replying to postgresql
mailing
lists. These lists do not set the reply-to to mailing list.
I don't know why it is so but I am sure it is been requested in past. I
found it
difficult to adjust initially but got used to it.
Not that it is much of a hassle for me. Its just different than what I
am/was
used to.
</OT>
HTH
Shridhar