Re: Blob like type - Mailing list pgsql-general

From Jeff Davis
Subject Re: Blob like type
Date
Msg-id 200206241855.LAA11558@smtp.ucsd.edu
Whole thread Raw
In response to Blob like type  (Patrick Nelson <pnelson@neatech.com>)
List pgsql-general
You're probably looking for either "text", "bytea", or possibly the large
object interface. If you have binary data use bytea, otherwise use text.

Both bytea and text are unlimited in size. Text automatically compresses the
contents.

Regards,
    Jeff

On Sunday 23 June 2002 11:54 am, Patrick Nelson wrote:
> Doing a move over from MySQL and I was wondering if there anything like the
> MySQL blob type?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



pgsql-general by date:

Previous
From: "Pablo Morales"
Date:
Subject: initdb
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] pg_restore: [archiver] input file does not appear to be a valid archive