Re: copy a text type. - Mailing list pgsql-novice

From David Raznick
Subject Re: copy a text type.
Date
Msg-id CAN4mCtm54CNtDYe4qt09pn9P8_zH5GtVzAODBhsWNxWEJM+ifg@mail.gmail.com
Whole thread Raw
In response to Re: copy a text type.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: copy a text type.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Sun, Jul 22, 2012 at 1:18 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> David Raznick <kindly@gmail.com> writes:
>> It there a way to create a new type, not a composite one, that acts in
>> exactly the same way as the text type except that it has a different
>> name.
>
> Perhaps a domain will do what you want?

Yes it absolutely should be.  Thanks.

The issue I have now is that psycopg2 the python library does not
extract the oid of the domain (only the oid of the original type) when
it describes the columns in returned query.  I am not sure if that is
an issue with libpq generally or this library.

>
>                         regards, tom lane

Thanks again.

David

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: copy a text type.
Next
From: Tom Lane
Date:
Subject: Re: copy a text type.