Re: Getting column size/type From DBI

According to the DBI docs:

column_info

Warning: This method is experimental and may change. 
  $sth = $dbh->column_info( $catalog, $schema, $table, $column );


Returns an active statement handle that can be used to fetch informati
+on about columns in specified tables
[download]

Give that a shot.

Update:
earthboundmisfit points out a, perhaps better, DBD::Pg specific answer with pg_size. note: use pg_type to get column data types.

Comment on Re: Getting column size/type From DBI Download Code

Replies are listed 'Best First'.
Re: Re: Getting column size/type From DBI by mpeppler (Vicar) on Jul 23, 2002 at 14:33 UTC
`column_info` is the generic answer. Unfortunately I've found that only a few DBD drivers actually implement it (for example DBD::Sybase will only implement this in the next release...) Michael	[reply] [d/l]