Re: Column existence - how to check?

In article <20011002(dot)213141(dot)2025187190(dot)16719(at)localhost(dot)localdomain>, "Mark
Higgins" <mghiggins(at)my-deja(dot)com> wrote:

> I'm writing an app that dynamically creates tables in a postgresql db.
>
> I'd like to determine if a column has been defined for a known table. Is
> there any way to do this? I've searched around quite a bit and haven't
> found anything.

Well, if your app is written in Perl, and you are using DBD::Pg, then you
can do something like this:

my $sth = $dbh->prepare('select * from mytable');
$sth->execute or die $dbh->errstr;
my @cols = @{ $sth->{NAME_lc} };
if (grep($_ eq 'col_i_want', @cols)) { ... }

--
Jeff Boes vox 616.226.9550
Database Engineer fax 616.349.9076
Nexcerpt, Inc. jboes(at)nexcerpt(dot)com