Here is the definition of a view I use to retrieve all of the tables and a
list of columns for tables that appear in the "public" schema ... I have
others that only retrieve a list of the table names and the views in the
public schema as well...
-- View: "vcat_pgcolumns"
-- DROP VIEW vcat_pgc
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
