>> is there a solution to find infos about a table?
>> eg: I want to know what field names and their types has a certain table
>> from a db.
I read TFM and found -c option to 'psql' and came up with this trick:
#!/some/where/perl
use CGI qw(:standard);
my $table = param('table');
my $fields = `psql $DBNAME -h $DBHOST -U $DBUSER -c \"\\d $table\" -q`;
print $fields;
..
is there something a little more elegant than this?
Cristian GAL
gal(at)mail(dot)com