On Thu, 03 Oct 2002 15:30:00 -0500 "R. Steven Rainwater" <[EMAIL PROTECTED]> wrote:
> I have some code that relies on getting the column
> name, type, and width, which I am porting for use with
> PostgreSQL and DBD::Pg. No problem with the name and type
> attributes but width relies on the $sth->{PRECISION}
> statement handle attribute which isn't supported in DBD::Pg.
> Is there any alternate way of finding out column widths
> using DBI (or SQL perhaps)?
You should always be able to query the appropriate database views to get
that information. I don't use Pg myself, so I'll have to refer you to
their fine manual for which ones they are.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
