Thread:

From
"ipig"
Date:
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.

Re:

From
Alvaro Herrera
Date:
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.


Re:

From
Bruce Momjian
Date:
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. +