Re: Type modifiers for DOMAIN - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Type modifiers for DOMAIN
Date
Msg-id 4B44841E020000250002DDD7@gw.wicourts.gov
Whole thread Raw
In response to Type modifiers for DOMAIN  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: fastgetattr & isNull
Next
From: Tom Lane
Date:
Subject: Re: fastgetattr & isNull