On 31-May-09, at 6:46 PM, Markus Hoenicka wrote: > Phil Longstaff writes: >> According to postgresql documentation, there is a standard >> information schema >> which exists in all databases >> (http://www.postgresql.org/docs/8.3/interactive/information- >> schema.html). Is >> there any easy way of having these extra tables *not* returned from >> dbi_conn_get_table_list() ? I suppose I can always get the list >> and remove >> them, but it would be easier if they weren't returned in the first >> place. >> > > I see from the implementation of the dbd_list_tables() function that > the pgsql driver removes all tables matching the regexp '^pg_' > anyway. These appear to be additional schemas as well. This could be > expanded to exclude 'information_schema' as well. Question is, should > this be the default? Would anyone *want* these tables to be listed? I > assume no one wants these, as they are implementation-specific to > PostgreSQL and should not be returned by a database-independent > function that lists all tables. I'm open to discussions.
The Ingres driver has the same 'issue', system tables are returned by default. I tend to think that no tables should be suppressed from the result by default when using *this* libdbi function. I think more input from actual use cases would be needed to see whether anything needs to be done. --Toby > > regards, > Markus > > -- > Markus Hoenicka > [email protected] > (Spam-protected email: replace the quadrupeds with "mhoenicka") > http://www.mhoenicka.de > > ---------------------------------------------------------------------- > -------- > Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > is a gathering of tech-side developers & brand creativity > professionals. Meet > the minds behind Google Creative Lab, Visual Complexity, Processing, & > iPhoneDevCamp as they present alongside digital heavyweights like > Barbarian > Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > _______________________________________________ > Libdbi-drivers-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com _______________________________________________ Libdbi-drivers-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
