| 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: | Whole Thread | Raw Message | 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.
| 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 |