pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedparse bind execute
4+ messages / 2 participants
[nested] [flat]
* parse bind execute
@ 1999-06-17 22:52 Steven Bradley <sbradley@llnl.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Steven Bradley @ 1999-06-17 22:52 UTC (permalink / raw)
To: pgsql-interfaces
I'm writing C programs to access a PostegreSQL database usng the libppq
interface. I am new to Postgres, so please excuse me if my question is too
basic.
I want to preparate (parse) and SQL insert statement and then in a loop,
bind the input variables and execute. Is this possible using libpq or any
other Posgres interface from C?
Thanks in advance....
Steven Bradley
Lawrence Livermore National Laboratory
Livermore California 94550
sbradley@llnl.go=v
^ permalink raw reply [nested|flat] 4+ messages in thread
* parse bind execute
@ 1999-06-17 22:57 Steven Bradley <sbradley@llnl.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Steven Bradley @ 1999-06-17 22:57 UTC (permalink / raw)
To: pgsql-interfaces
I'm writing C programs to access a PostegreSQL database usng the libppq
interface. I am new to Postgres, so please excuse me if my question is too
basic.
I want to preparate (parse) and SQL insert statement and then in a loop,
bind the input variables and execute. Is this possible using libpq or any
other Posgres interface from C?
Thanks in advance....
Steven Bradley
Lawrence Livermore National Laboratory
Livermore California 94550
sbradley@llnl.go=v
^ permalink raw reply [nested|flat] 4+ messages in thread
* parse bind execute
@ 1999-06-18 23:29 Steven Bradley <sbradley@llnl.gov>
1999-06-20 09:23 ` Re: [INTERFACES] parse bind execute Michael Meskes <meskes@postgreSQL.org>
0 siblings, 1 reply; 4+ messages in thread
From: Steven Bradley @ 1999-06-18 23:29 UTC (permalink / raw)
To: pgsql-interfaces
I'm writing C programs to access a PostegreSQL database usng the libppq
interface. I am new to Postgres, so please excuse me if my question is too
basic.
I want to preparate (parse) and SQL insert statement and then in a loop,
bind the input variables and execute. Is this possible using libpq or any
other Posgres interface from C?
Thanks in advance....
Steven Bradley
Lawrence Livermore National Laboratory
Livermore California 94550
sbradley@llnl.go=v
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] parse bind execute
1999-06-18 23:29 parse bind execute Steven Bradley <sbradley@llnl.gov>
@ 1999-06-20 09:23 ` Michael Meskes <meskes@postgreSQL.org>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Meskes @ 1999-06-20 09:23 UTC (permalink / raw)
To: pgsql-interfaces
On Fri, Jun 18, 1999 at 04:29:35PM -0700, Steven Bradley wrote:
> I'm writing C programs to access a PostegreSQL database usng the libppq
> interface. I am new to Postgres, so please excuse me if my question is too
> basic.
>
> I want to preparate (parse) and SQL insert statement and then in a loop,
> bind the input variables and execute. Is this possible using libpq or any
> other Posgres interface from C?
It is possible via ecpg the embedded SQL preprocessor for C. But be aware
that the PREPARE statement is only simulated since the backend does not
support it. That means you can do what you saif, but in fact everytime you
issue your INSERT it is parsed by the backend yet again.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-06-20 09:23 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-17 22:52 parse bind execute Steven Bradley <sbradley@llnl.gov>
1999-06-17 22:57 parse bind execute Steven Bradley <sbradley@llnl.gov>
1999-06-18 23:29 parse bind execute Steven Bradley <sbradley@llnl.gov>
1999-06-20 09:23 ` Michael Meskes <meskes@postgreSQL.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox