postgres table query not getting all names

Dr. Hawkins dochawk at gmail.com
Mon Jul 17 15:29:17 EDT 2017


On Sun, Jul 16, 2017 at 12:25 PM, Bob Sneidar via use-livecode <
use-livecode at lists.runrev.com> wrote:

> If there is a built in function for getting the schema of the particular
> database, I would use that. For instance you can query sqLite master
> database for a list of tables using:
>

That's where I started, but getTableNames() frequently missed tables.
Adding my own query ws a self-defense.

I don't remember whether I reported this and the mothership couldn't
reproduce, or whether it clearly couldn't be reproduced.   Iirc, it only
affected postgres, and that my own function uses getTableNames() for mySQL

There is no possibility of allowing access to my database; confidential
information from far too many people.
-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462



More information about the use-livecode mailing list