Groups > comp.databases.postgresql > #613

Re: Help databases and schemes

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!not-for-mail
From	"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups	comp.databases.postgresql
Subject	Re: Help databases and schemes
Date	Fri, 21 Nov 2014 23:55:38 +0100
Lines	40
Message-ID	<cd9u7bFntcdU1@mid.uni-berlin.de> (permalink)
References	<3ec57947-4f92-46c0-8101-9628a62250a7@googlegroups.com> <7b195d3f-4b82-4d92-adab-e77cecc72a2b@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	news.uni-berlin.de 4J1tmliDRDqJOk9iyzb0DATN5lVvTwuGZXSK9WFcLSdZPW7wk=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0
In-Reply-To	<7b195d3f-4b82-4d92-adab-e77cecc72a2b@googlegroups.com>
Xref	csiph.com comp.databases.postgresql:613

Show key headers only | View raw

On 21.11.2014 14:06, Daniel Quisbert wrote:
> Sorry, I was not clear.
>
> I have the following information:
>
> A database (DB-A)
> B database (DB-B)
> C database (db-C)
>
> I need to create a data base GEO_DB (with sche X, Y, Z), where the amount:
>
> * The content of db-A in Scheme X,
> * The contents of db-B in the scheme and
> * And db-C content in the Z scheme:
>
> I hope I was a little Calre this time:-)
>
> Any solution strategy?
>

1.) Is it really required to put all the tables from the 3 databases into 1 database? 
You can easily serve several databases from the same server/instance.

2.) Is there a collision of table names or functions in A, B and C? You can write SQL 
to check it.

If yes different schema names are a must. If no it would be an option.

3.) Is the data going to be merged? Then the data structures must be analyzed, and 
migration scipts be written. Hire a consultant.

Some postgresql support is provided by stackoverflow.com. The best place are the 
mailing list, you can read them using NNTP at news.gmane.org. And then there are the 
original lists at postgresql.org.

If you just ask "can I put the tables from A, B and C into D then the answer is yes. 
But the interesting question you have to answer is it a solution to my problem (what 
problem), and what options do I have.

/Str.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help databases and schemes Daniel Quisbert <dani3l.quisb3rt@gmail.com> - 2014-11-20 14:05 -0800
  Re: Help databases and schemes "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2014-11-20 23:59 +0100
  Re: Help databases and schemes Daniel Quisbert <dani3l.quisb3rt@gmail.com> - 2014-11-21 05:06 -0800
    Re: Help databases and schemes "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2014-11-21 23:55 +0100
      Re: Help databases and schemes Fredrik Jonson <fredrik@jonson.org> - 2014-11-22 16:51 +0000

csiph-web