Re: [GENERAL] Check If PostgreSQL Table Exists

[Madison Kelly]

[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();
if ( $table_num < 1 )
{
        # Create the missing table
}
else
{
        # It exists!
}

Hope that helps!

Madison


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings