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

From: Howard Wilkinson <howard(at)cohtech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Querying the schema for column widths - what syntax do I use?
Date: 2008-02-21 10:44:32
Message-ID: 47BD5610.7070608@cohtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In MySQL I can do either: a "DESCRIBE" command or do "SELECT COLUMNS"
command. And then parse the result for the length in the type column of
the row returned. How would I do a similar function using PostgreSQL - I
have tried to find this in the manuals and in this mailing list but not
found any pointers to get me started.

Apologies for asking such a simple question but I am being a bit lazy as
I want to get on with releasing the MyDNS code.

Regards, Howard.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-02-21 11:06:48 Re: Querying the schema for column widths - what syntax do I use?
Previous Message Richard Huxton 2008-02-21 10:20:02 Re: ts_headline