Re: Join with other database's table

From: Chris Bitmead <chris(at)bitmead(dot)com>
To: Sungchul Park <scpark(at)gen128(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Join with other database's table
Date: 2000-05-23 11:21:20
Message-ID: 392A69B0.3ECACF34@bitmead.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2000-05-23 12:17:34 Timezones on Tru64 (Digital Unix)
Previous Message Sungchul Park 2000-05-23 11:17:08 Re: Re: Join with other database's table