On Wed, Feb 19, 2003 at 01:10:00PM -0800, David Wheeler wrote: > On Wednesday, February 19, 2003, at 01:03 AM, Ron Savage wrote: > > >Is there a Postgres DBI/DBD::Pg call which will retrieve the column > >attributes the way "show columns from $table" does under MySQL? > > column_info(). > > http://search.cpan.org/author/TIMB/DBI/DBI.pm#column_info
I'm not sure this is supported by DBD::Pg: it's not mentioned there (and most supported methods are). I haven't had a chance to try yet, though--I'll see if I can do it later. In the meantime, $attrs= $dbh->func($table,'table_attributes') is documented in DBD::Pg, and works well enough. --keith -- [EMAIL PROTECTED] public key: http://wombat.san-francisco.ca.us/kkeller/kkeller.asc alt.os.linux.slackware FAQ: http://wombat.san-francisco.ca.us/cgi-bin/fom