Re: Type modifiers for DOMAIN

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Takahiro Itagaki" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Type modifiers for DOMAIN
Date: 2010-01-06 18:37:50
Message-ID: 4B44841E020000250002DDD7@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:

> This feature would be useful for migration
> from other DBMSes that have non-standard data types.

Domains can indeed be useful to allow migration -- if they are used
as intended. If you identify all of the unique data domains on your
source platform and define the columns with domains rather than bare
types, you can easily identify the appropriate mapping on some other
platform and declare the appropriate domains there. Migration is
then easy.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-01-06 18:38:59 Re: fastgetattr & isNull
Previous Message Robert Haas 2010-01-06 18:32:24 Re: fastgetattr & isNull