FAQ
Using this code below (particularly heap_open) somehow i can fetch all
table column name, and put in on list of string. Before raw_parsetree is
processed by analyze part.

------start code ----------------
---------------------------------

RangeVar *relation = makeNode(RangeVar);
relation->schemaname = NULL;
relation->catalogname = NULL;
relation->relname = "pg_class"; //table name
relation->inhOpt = INH_DEFAULT;
relation->istemp = false ;
relation->alias = NULL;

Relation Rel;
LOCKMODE lockmode = AccessShareLock;

Rel = heap_open(TableSpaceRelationId,lockmode);
Value *attrname ;
TupleDesc td;
td = Rel->rd_att;

List *colnames;
colnames = NIL;
int z;
int maxatribut = td->natts;
Form_pg_attribute fpa;

for (z=0;z<maxatribut;z++)
{
fpa = td->attrs[z];
attrname = makeString(pstrdup(NameStr(fpa->attname)));
colnames = lappend(colnames,attrname); //this where list cols name
colected
}

------end code ----------------
---------------------------------

My question, is there same kind function that i can use to get table
content (tuple)?

Thank You.
--
Mohammad Heykal Abdillah <heykal.abdillah@gmail.com>

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJun 1, '10 at 7:50a
activeJun 1, '10 at 7:50a
posts1
users1
websitepostgresql.org...
irc#postgresql

1 user in discussion

Mohammad Heykal Abdillah: 1 post

People

Translate

site design / logo © 2022 Grokbase