Hi, I find that the relid of tables in all user created databases are having a
value greater than 10,000 while the non user created tables produces a relid of
value less than 10,000.
For eg., the query transformed from the meta command "\dt" or "\l" gave me
'relid' values like 2615, 1259 and 12
s
Date: Fri, 9 Jan 2015 00:46:30 +1300
Subject: Re: [HACKERS] List of table names of a DB
From: dgrowle...@gmail.com
To: in.live...@live.in
CC: pgsql-hackers@postgresql.org
On 8 January 2015 at 22:41, Deepak S wrote:
Hello, I am unable to find the function which retrieves the 'list of
Hello, I am unable to find the function which retrieves the 'list of names of
the tables' used in a DB.
Reason: I need a mechanism by which I can extract the names of the tables used
in a query which has been parsed. My plan is to check for a match of each word
in the query with a list of names
Hello, I am unable to find the function which retrieves the 'list of names of
the tables' used in a DB.
Reason: I need a mechanism by which I can extract the names of the tables used
in a query which has been parsed. My plan is to check for a match of each word
in the query with a list of names
