revDatabaseColumnNames fails to recognize table

Mike Kerner MikeKerner at roadrunner.com
Tue Jan 31 10:35:45 EST 2017


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 <
use-livecode at lists.runrev.com> wrote:

> On Mon, Jan 30, 2017 at 8:07 PM, Mike Kerner via use-livecode <
> use-livecode at lists.runrev.com> 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
> use-livecode at lists.runrev.com
> 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."



More information about the use-livecode mailing list