We help IT Professionals succeed at work.
Get Started

Postgres and bytea

cossy74
cossy74 asked
on
670 Views
Last Modified: 2008-01-09
Hi,

Below is the table in postgreSQL:
//---------------------------
// tblUsers
//---------------------------
// user_id int
// csv_data bytea
// image bytea
//---------------------------

My question is using c++, what is the code for inserting and retrieving a row from the table defined above?

NOTES - What i have discovered ( I may be wrong ):
1) I think the sql query needs to be "INSERT INTO tblUsers values ($1, $2, $3);"
2) In my understanding( which i very limited), i have to use pqxx::prepare::declaration to declare a parameter, but i am unsure of how to add mulitple parameters.
3) After the declaration, i believe i have to use prepare::invocation to assign the value of the parameters.
4) Finally i believe i need to call the execute on the invocation.
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE