Re: [HACKERS] List of table names of a DB

2015-01-08 Thread Tatsuo Ishii
but do you know where these tables information of a DB gets stored? Or can you suggest me a mechanism(needn't be fully perfect) to extract the table names? I went through the parser of postgres but it was confusing. Thanks Date: Fri, 9 Jan 2015 00:46:30 +1300 Subject: Re: [HACKERS] List

Re: [HACKERS] List of table names of a DB

2015-01-08 Thread Mark Kirkwood
these tables information of a DB gets stored? Or can you suggest me a mechanism(needn't be fully perfect) to extract the table names? I went through the parser of postgres but it was confusing. Thanks Date: Fri, 9 Jan 2015 00:46:30 +1300 Subject: Re: [HACKERS] List of table names of a DB From: dgrowle

Re: [HACKERS] List of table names of a DB

2015-01-08 Thread Deepak S
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 in.live...@live.in wrote: Hello, I am unable to find the function which retrieves the 'list of names

Re: [HACKERS] List of table names of a DB

2015-01-08 Thread Mark Kirkwood
perfect) to extract the table names? I went through the parser of postgres but it was confusing. Thanks 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

Re: [HACKERS] List of table names of a DB

2015-01-08 Thread Lukas Fittl
On Fri, Jan 9, 2015 at 7:14 AM, Deepak S in.live...@live.in wrote: Sorry, it's not about querying. I am implementing an invalidation mechanism for Postgres Query Cache as part of my masters project. In order to this, I need to store details(like name) of each table the query uses. In essence,

Re: [HACKERS] List of table names of a DB

2015-01-08 Thread David Rowley
On 8 January 2015 at 22:41, Deepak S in.live...@live.in wrote: Hello, I am unable to find the function which retrieves the 'list of names of the tables' used in a DB. You may find what you want in: select table_name from information_schema.tables;