Re: Check If PostgreSQL Table Exists

[Madison Kelly <linux@xxxxxxxxxxx>]

dhilchrist@xxxxxxxxx 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