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

2008-02-22 Thread Howard Wilkinson
Tino Wildenhain wrote: Hi Howard, 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

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

2008-02-21 Thread Howard Wilkinson
Richard Huxton wrote: 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

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

2008-02-21 Thread Howard Wilkinson
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 "SELE