SELECT * FROM information_schema.columns That's from http://stackoverflow.com/questions/21728073/postgressql-search-all-tables-of-a-database-for-a-field-called-like-active
or SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE'; from http://stackoverflow.com/questions/14730228/postgres-query-to-list-all-table-names On Tue, Jan 31, 2017 at 10:27 AM, Dr. Hawkins via use-livecode < [email protected]> wrote: > On Mon, Jan 30, 2017 at 8:07 PM, Mike Kerner via use-livecode < > [email protected]> wrote: > > > What's the type of db, and did you try sending a pragma to pull the table > > names to doublecheck? > > > > It's postgreSQL > > I'll be doing that kind of read today. I was so mystified yesterday, and > my wife started serving dinner, so . . . > > I've used cut & paste for the name of the table; I only went to > revDatabaseColumnNames() when using the name it *should *have, but get the > same results. > > I do have my own tableNames() function, as the rev version sometimes fails > to list them all . . . > > > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
