> -----Original Message----- > From: Joe Conway [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 19, 2002 5:25 PM > To: Joel Burton > Cc: Pgsql-Hackers@Postgresql. Org > Subject: Re: [HACKERS] Exposed function to find table in schema search > list? > > > Joel Burton wrote: > > Is there a function already in the backend to return a class > oid, given a > > name, by looking up the table in the current_schemas path? Would it make > > sense for us to expose this, or write one, so that this small > wheel doesn't > > have to be re-invented everytime someone wants to find a table > by just the > > name? > > > > Something like: > > > > findtable(text) returns oid > > findtable("foo") -> oid of foo (given current search path) > > findtable("s.foo") -> oid of s.foo > > > > I can write something in plpgsql (iterating over the array, > checking each, > > etc.), however, it would be nice if something was already there. > > I think this already exists: > > test=# select 'joe.foo'::regclass::oid; > oid > -------- > 125532 > (1 row) > > test=# select 'public.foo'::regclass::oid; > oid > -------- > 125475 > (1 row) > > test=# select 'foo'::regclass::oid; > oid > -------- > 125475 > (1 row) > > test=# select current_schema(); > current_schema > ---------------- > public > (1 row)
Perfect! I was hoping to avoid re-creating the wheel. Thanks, Joe. Is the use of regclass going to prove to be very implementation-specific? Would it make sense for us to create a function that abstracts this? - J. Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
