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
|
|---|