pgsql embedded again!
| От | Esteban Gutierrez Abarzua |
|---|---|
| Тема | pgsql embedded again! |
| Дата | |
| Msg-id | Pine.LNX.4.21.0110221050001.3475-100000@sauce.chillan.ubiobio.cl обсуждение исходный текст |
| Ответы |
Re: pgsql embedded again!
|
| Список | 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?
В списке pgsql-sql по дате отправления: