Re: Join with other database's table - Mailing list pgsql-general

From Chris Bitmead
Subject Re: Join with other database's table
Date
Msg-id 392A69B0.3ECACF34@bitmead.com
Whole thread Raw
In response to Join with other database's table  (Sungchul Park <scpark@gen128.com>)
List pgsql-general
Sungchul Park wrote:
>
> Because I want to use same table name. I mean... For example, I have a
> BBS code. That code store data into 'pubbbs' table. As you know I need
> 4 tables for one service.
> Yes, I can use 4 different table name. As 'pubbbs_en', 'pubbbs_jp',
> 'pubbbs_kr', 'pubbbs_cn'. But I will make much more services and there
> will be too many table in one database.

Too many in what way?


Personally I think the whole idea of having 4 tables that store the same
kind of data will lead you to problems later on. I think I'd have a
language attribute in the one table.


> (Could you understand? I am not
> well english speaker.)
> I like simple and it looks simple way to allocate datebase for each
> language. I believed this schema is not special one. Many DBMSs are
> support this, even MySQL.

pgsql-general by date:

Previous
From: Sungchul Park
Date:
Subject: Re: Re: Join with other database's table
Next
From: Stephane Bortzmeyer
Date:
Subject: Timezones on Tru64 (Digital Unix)