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