how do i get field names of a table in postgresql?

[Lastknight]

Hi all,

I need to get the field names of a table in postgresql?

Like if a table called "employee" which has several fields like 'name','id','address','phone','workexperience'..et c..

I need to fetch the field names and print that into my output..

I have used the query called "show by column from employees"

Its not working...can some body help me to solve this problem.

thanks in advance...

Barani

[miller]

Typically, the query one uses to obtain information about a SQL based table is "DESC employee".

my $sth = $dbh->prepare(q{DESC employee});
$sth->execute or die $dbh->errstr;
while (my $hashref = $sth->fetchrow_hashref) {
    print $hashref->{Field}, "\n";
}
$sth->finish; undef $sth;
 

-Miller

[Lastknight]

hi miller,
thanks for your help...Here is the code i have tried with your help...

#!/usr/bin/perl
use CGI;
use DBI;
 
$sth="dbi:Pg:dbname=barani";
$dbh=DBI->connect("$sth","postgres","india")or die "can't connect$DBI::errstr\n\n";
 
 
$sth = $dbh->prepare(q{DESC employee});
$sth->execute or die $dbh->errstr;
while ($hashref = $sth->fetchrow_hashref) {
    print $hashref->{Field}, "\n";
}
$sth->finish; undef $sth;
 

But i am getting the output as
"DBD::Pg::st execute failed: ERROR: parser: parse error at or near "DESC" at character 1 at empp.cgi line 10.
ERROR: parser: parse error at or near "DESC" at character 1 at empp.cgi line 10."

Please let me know how to solve this issue..

Barani

[miller]

You're going to have to ask the people in the PostgreSQL Forum what the proper query is for inspecting a tables format. It appears that "DESC table" doesn't work, but maybe they know an alternative.

- Miller

[Lastknight]

Thanks alot for your guidance Mr .miller..

Hope i will get more help from you..