[GENERAL] Check If PostgreSQL Table Exists

Dear All, How To Check If PostgreSQL Table Exists in the Database Using Perl. Dhilchrist ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes d

Re: [GENERAL] Check If PostgreSQL Table Exists

[EMAIL PROTECTED] wrote: Dear All, How To Check If PostgreSQL Table Exists in the Database Using Perl. Dhilchrist Here is what I do... $DBreq=$DB->prepare("SELECT COUNT(*) FROM pg_tables WHERE tablename='foo'") || die $DBI::errstr; $DBreq->execute(); my ($table_num)=$DBreq->fetchrow_array();