Re: Querying the schema for column widths - what syntax do I use?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Howard Wilkinson <howard(at)cohtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Querying the schema for column widths - what syntax do I use?
Date: 2008-02-21 11:06:48
Message-ID: 47BD5B48.4020505@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howard Wilkinson wrote:
> I am working on some upgrades to the MyDNS open source product. I have
> some expertise in MySQL but am not overly familiar with PostgreSQL and
> need some guidance on how to query the schema for the maximum size of
> data a column can hold.

Unless you're after PG-specific stuff, it's probably best to use the
information-schema.

http://www.postgresql.org/docs/8.3/static/information-schema.html

This has a standard layout cross-database, so will help you to extend
you app across other systems. I think it's supported in the latest
version of MySQL too.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Davies 2008-02-21 11:10:30 Re: ts_headline
Previous Message Howard Wilkinson 2008-02-21 10:44:32 Querying the schema for column widths - what syntax do I use?