Обсуждение: PG equivalent to Sybase varbinary

Anybody know what the Postgresql equivalent to a Sybase varbinary data type
is?  I have a package that provides ddl to store a 40 byte/char? varbinary
column in a table and it is failing against postrgresql.

Thanks for any help and if more info is need to answer, please let me know.

Bill Pfeiffer

On Monday 06 October 2003 15:40, Bill Pfeiffer wrote:
> Anybody know what the Postgresql equivalent to a Sybase varbinary data type
> is?  I have a package that provides ddl to store a 40 byte/char? varbinary
> column in a table and it is failing against postrgresql.

Sounds like "bytea" to me - or have you rejected that?

--  Richard Huxton Archonet Ltd

Thanks for the response.  I'll look into re-running the ddl using the bytea
datatype the next time I perform the setup I'm using. (I used a Sybase SQL
Anywhere db in the meantime to get me back on track with the task at hand).

Thanks again,

Bill
"Richard Huxton" <dev@archonet.com> wrote in message
news:200310080945.06497.dev@archonet.com...
> On Monday 06 October 2003 15:40, Bill Pfeiffer wrote:
> > Anybody know what the Postgresql equivalent to a Sybase varbinary data
type
> > is?  I have a package that provides ddl to store a 40 byte/char?
varbinary
> > column in a table and it is failing against postrgresql.
>
> Sounds like "bytea" to me - or have you rejected that?
>
> -- 
>   Richard Huxton
>   Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>