Re: npgsql and postgres enum type - Mailing list pgsql-general

From Merlin Moncure
Subject Re: npgsql and postgres enum type
Date
Msg-id b42b73150910151142pdfb30f7l138b24d57644feaf@mail.gmail.com
Whole thread Raw
In response to npgsql and postgres enum type  (danclemson <danclemson@gmail.com>)
Responses Re: npgsql and postgres enum type
Re: npgsql and postgres enum type
List pgsql-general
On Thu, Oct 15, 2009 at 12:31 PM, danclemson <danclemson@gmail.com> wrote:
>
> Hi,
>
> As postgres now has enum type, does npgsql driver support the enum type?
>
> I use c# and npgsql as databse driver.  One of the database stored procedure
> takes enum as its parameter.
>
> What will be the DbType for postgres enum type?

that's really a npgsql question, but as long as you have access to the
sql being used, you should be able to work around it by altering the
sql like this:

select some_function('abc'::the_enum);

merlin

pgsql-general by date:

Previous
From: danclemson
Date:
Subject: npgsql and postgres enum type
Next
From: William Temperley
Date:
Subject: Re: npgsql and postgres enum type