Re: PGSQL insert data to a oid column using SOCI

What is the correct data type to be used for large objects then?

On Thu, 30 Jul 2020, 00:31 David Raymond, <David(dot)Raymond(at)tomtom(dot)com> wrote:

> https://www.postgresql.org/docs/current/datatype-oid.html
>
>
>
> Are you sure OID is what you really want? An OID is basically an integer.
> Not something you can store text or xml data into.
>
>
>
>
>
> *From:* Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
> *Sent:* Wednesday, July 29, 2020 2:17 PM
> *To:* pgsql-novice(at)lists(dot)postgresql(dot)org
> *Subject:* PGSQL insert data to a oid column using SOCI
>
>
>
> Hi All,
>
> I am using c++ with soci to insert oid values to a table.
>
>
>
> Table structure is as follows,
>
>
>
> *CREATE* *TABLE* test_table (
>
> key *varchar*(200) *NULL*,
>
> value *oid* *NULL*
>
> );
>
>
>
> Value is a large xml file given as std::string.
>
> What is the correct way to insert oid data using binding variables.
>
> Used code snippet is given below which is not working.
>
>
>
> std::string key = "test key";
>
> std::string value = "test xml";
>
> std::string sql = "insert into test_table(key,value) values (:KEY, :VALUE)
>
> soci:use(key);
>
> soci:use(value);
>
>
>
> soci::statement st(session);
>
> st.prepare(sql)
>
> st.execute()
>
>
>
> Thanks!
>
>
>
>
>
>
> --
>
> G.K.M.C Sajeewa
>
>
>