[SQL] PG equivalent to Sybase varbinary

[Bill Pfeiffer]

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



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [SQL] PG equivalent to Sybase varbinary

[Bill Pfeiffer]

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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 [EMAIL PROTECTED] so that your
>   message can get through to the mailing list cleanly
>



---(end of broadcast)---
TIP 8: explain analyze is your friend