pgsql embedded again!

From: Esteban Gutierrez Abarzua <esgutier(at)sauce(dot)chillan(dot)ubiobio(dot)cl>
To: pgsql-sql(at)postgresql(dot)org
Subject: pgsql embedded again!
Date: 2001-10-22 13:51:00
Message-ID: Pine.LNX.4.21.0110221050001.3475-100000@sauce.chillan.ubiobio.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hi.
I still have the data type problem.
I am working with the postgresql system catalog and I wanna get all
relname of pg_class relation on a C variable.

-----> \d pg_class

Attribute | Type | Modifier
--------------+-----------+----------
relname | name |
reltype | oid |
relowner | integer |
relam | oid |
.........
......
.....
...
..

C program.

EXEC SQL BEGIN DECLARE SECTION;
VARCHAR tabla[50]; I also tried with char tabla[50];
......
....
.
EXEC SQL END DECLARE SECTION;


I used a cursor for results.....
EXEC SQL DECLARE T99 CURSOR FOR select relname from pg_class

now I want to get the results of query... then:

EXEC SQL OPEN T99;
EXEC SQL FETCH IN T99 INTO :tabla; here is the problem, I can't
to get on tabla variable results.
I think that may be the data type ..... I don't know ....


do you know about psql embedded mail list?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Masaru Sugawara 2001-10-22 15:19:00 Re: Identifying obsolete values
Previous Message guard 2001-10-22 09:14:32 can't update 'c:\windows'