No title
Hi,
I am now studying PostgreSQL.
in your web site:
Developer's Frequently Asked Questions (FAQ) for PostgreSQL
Technical Questions
2.1) How do I efficiently access information in tables from the backend code?
Since heap_open function needs the oid of the relation, how can I get those parameters for heap_open?
Suppose that at the beginning, I only know the name of the relation, which functions I need to call?
Best regards.
ipig wrote:
2.1) How do I efficiently access information in tables from the backend code?
Since heap_open function needs the oid of the relation, how can I get
those parameters for heap_open?Suppose that at the beginning, I only know the name of the relation,
which functions I need to call?
You can create a RangeVar using makeRangeVar and call heap_openrv().
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Alvaro Herrera wrote:
ipig wrote:
2.1) How do I efficiently access information in tables from the backend code?
Since heap_open function needs the oid of the relation, how can I get
those parameters for heap_open?Suppose that at the beginning, I only know the name of the relation,
which functions I need to call?You can create a RangeVar using makeRangeVar and call heap_openrv().
Or just look in the code to see how other code is calling heap_open().
--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +