Received: from gamera.begeek.com (cr714364-a.lndn1.on.wave.home.com [24.114.87.48]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5TFesa16619 for ; Fri, 29 Jun 2001 11:40:54 -0400 (EDT) (envelope-from craigl@begeek.com) Received: from jigra (IDENT:craigl@jigra [10.2.0.13]) by gamera.begeek.com (8.9.3/8.9.3) with ESMTP id LAA26705 for ; Fri, 29 Jun 2001 11:36:46 -0400 Subject: create datatype From: Craig Longman To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution/0.10 (Preview Release) Date: 29 Jun 2001 11:36:45 -0400 Message-Id: <993829006.11585.2.camel@jigra.begeek.com> Mime-Version: 1.0 X-Archive-Number: 200106/472 X-Sequence-Number: 3775 some of the databases i'm trying to convert to postgres use user-defined datatypes to simplify/standardize table creation. in postgres, the only thing similar i can find is the 'CREATE TYPE' command, but it is a little different, and substantially more than i need. all i need is basically #DEFINE functionality. so, its more like aliasing a datatype to simply map directly to a specific postgres datatype, for (var)chars, a specific length is also provided. is this just not available in pgsql right now? cheers, -- CraigL->Thx(); Be Developer ID: 5852