in reply to Re: DBI - MySQL vs. PgSQL
in thread DBI - MySQL vs. PgSQL

> To get a list of all non system tables using SQL try:

> select * from pg_tables where tablename not like 'pg_%' <CODE>

Which is fine until you switch to another database in the future, at which time you have to modify the script again.

In general, I choose to try to always use non-vendor specific solutions. Come to think of it, that's why DBI exists in the first place!

rick