RE: PGSQL insert data to a oid column using SOCI

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