Postgres Pro
Downloads
Home   >   mailing lists

Thread: Embedded SQL in C

Embedded SQL in C

From
rodneyr@embratel.com.br
Date:
What is the best way to work with embedded SQL in C for PostgreSQL?

I've tried the "ecpg" but I wasn't able to develop a simple program with the
documentation in the "PostgreSQL Programmer's Guide". Where can I find a better
documentation for beginners and, what is more important, examples?

Thanks in advance.

Rodney.

Re: [INTERFACES] Embedded SQL in C

From
Thomas Lockhart
Date:
> What is the best way to work with embedded SQL in C for PostgreSQL?
> I've tried the "ecpg" but I wasn't able to develop a simple program with the
> documentation in the "PostgreSQL Programmer's Guide". Where can I find a better
> documentation for beginners and, what is more important, examples?

As for most of our work, the documentation lags the implementation.
afaik there is no other specific documentation for ecpg. I would
suggest two paths to take:
1) Get a generic book on SQL which covers embedded C. ecpg tries to
follow published standards and common conventions.
2) Look at embedded code examples in the Postgres source tree. There
are several in src/interfaces/ecpg/test/

And, when you understand how to do it, consider writing a "HowTo" doc!
I'd be very happy to include it in the Programmer's Guide, and will
help to edit and format it. The content (or lack thereof, as you have
discovered) is the most important thing.

Good luck.
                       - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California

Re: [INTERFACES] Embedded SQL in C

From
Ivo Simicevic
Date:
On Sat, Sep 11, 1999 at 06:24:22PM -0300, rodneyr@embratel.com.br wrote:
> What is the best way to work with embedded SQL in C for PostgreSQL?
> 
> I've tried the "ecpg" but I wasn't able to develop a simple program with the
> documentation in the "PostgreSQL Programmer's Guide". Where can I find a better
> documentation for beginners and, what is more important, examples?
> 
> Thanks in advance.
> 
> Rodney.
> 

If it could be of any help check  http://www.ultra.hr/gpl/ecpg

Ivo.

Re: [INTERFACES] Embedded SQL in C

From
Michael Meskes
Date:
On Sat, Sep 11, 1999 at 06:24:22PM -0300, rodneyr@embratel.com.br wrote:
> I've tried the "ecpg" but I wasn't able to develop a simple program with the
> documentation in the "PostgreSQL Programmer's Guide". Where can I find a better
> documentation for beginners and, what is more important, examples?

There is some documentation in sgml in the source tree. Other than that I
can only offer the demo sources.

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@Fam-Meskes.De           | Use PostgreSQL!