Re: [SQL] How to obtain the list of data table name only

2005-07-15 Thread Neil Dugan
On Thu, 2005-07-14 at 15:24 -0700, [EMAIL PROTECTED] wrote: > Hi, > > I am wondering if anyone can tell me how I can obtain only the list of > data table in postgresql without function and other ancillary tables. I > hope that I can add a tag that can filter only data table. > > I am using the fo

Re: [SQL] How to obtain the list of data table name only

2005-07-15 Thread Richard Huxton
[EMAIL PROTECTED] wrote: Hi, I am wondering if anyone can tell me how I can obtain only the list of data table in postgresql without function and other ancillary tables. I hope that I can add a tag that can filter only data table. I am using the following SQL Statement: "SELECT TABLE_NAME, TAB

[SQL] How to obtain the list of data table name only

2005-07-14 Thread sunny076
Hi, I am wondering if anyone can tell me how I can obtain only the list of data table in postgresql without function and other ancillary tables. I hope that I can add a tag that can filter only data table. I am using the following SQL Statement: "SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SC