subdir = contrib/oid2name

top_builddir =/pgtop/

top_builddir =../..

include$(top_builddir)/src/Makefile.global

overrideCPPFLAGS += -I$(libpq_srcdir)

if(systables==1)

sprintf(todo,"selectoid,relname from pg_class order by relname");

sprintf(todo,"selectrelfilenode,relname from pg_class order by relname");

sprintf(todo,"selectoid,relname from pg_class where relname not like 'pg_%%' order by relname");

sprintf(todo,"selectrelfilenode,relname from pg_class where relname not like 'pg_%%' order by relname");

sql_exec(conn,todo,NULL);

}

todo= (char*)malloc (1024);

sprintf(todo,"selectoid,relname from pg_class where relname = '%s'",tablename);

sprintf(todo,"selectrelfilenode,relname from pg_class where relname = '%s'",tablename);

returnvalue=sql_exec(conn,todo,1);

todo= (char*)malloc (1024);

sprintf(todo,"selectoid,relname from pg_class where oid = %i",oid);

sprintf(todo,"selectrelfilenode,relname from pg_class where oid = %i",oid);

returnvalue=sql_exec(conn,todo,1);

<ULink url="http://GiST.CS.Berkeley.EDU:8000/gist/">http://GiST.CS.Berkeley.EDU:8000/gist/</ULink>

with more on different indexing and sorting schemes at

<ULink url="http://s2k-ftp.CS.Berkeley.EDU:8000/personal/jmh/">http://s2k-ftp.CS.Berkeley.EDU:8000/personal/jmh/</ULink>

<ULink url="http://s2k-ftp.CS.Berkeley.EDU:8000/personal/jmh/">http://s2k-ftp.CS.Berkeley.EDU:8000/personal/jmh/</ULink>.

And there is more interesting reading at the Berkely database site at

<ULink url="http://epoch.cs.berkeley.edu:8000/">http://epoch.cs.berkeley.edu:8000/</ULink>.

And there is more interesting reading at

<ULink url="http://epoch.cs.berkeley.edu:8000/">http://epoch.cs.berkeley.edu:8000/</ULink> and

<ULink url="http://www.sai.msu.su/~megera/postgres/gist/">http://www.sai.msu.su/~megera/postgres/gist/</ULink>.

</para>

<Para>