Re: PGSQL insert data to a oid column using SOCI

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
Cc: David Raymond <David(dot)Raymond(at)tomtom(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: PGSQL insert data to a oid column using SOCI
Date: 2020-07-30 14:28:52
Message-ID: 20200730142852.GW12375@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Greetings,

* Chamath Sajeewa (csgsajeewa(at)gmail(dot)com) wrote:
> What is the correct data type to be used for large objects then?

I'd suggest you seriously consider if you can just use a 'bytea' for the
object rather than the actual large object system. 'bytea' is limited
to 1GB, though you could chunk up larger objects if needed.

Thanks,

Stephen

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Frost 2020-07-30 14:36:00 Re: PGSQL returning into in insert statement
Previous Message Chamath Sajeewa 2020-07-30 06:56:26 Re: PGSQL returning into in insert statement