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.abdil...@gmail.com>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
