Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying the schema for column widths - what syntax do I use? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Querying the schema for column widths - what syntax do I use?
Date
Msg-id 20080221143706.GH22594@a-kretschmer.de
Whole thread Raw
In response to Re: Querying the schema for column widths - what syntax do I use?  (Howard Wilkinson <howard@cohtech.com>)
List pgsql-general
Tree view 
am  Thu, dem 21.02.2008, um 12:42:51 +0000 mailte Howard Wilkinson folgendes:
> SO I can do something like this?
>
> select character_maximum_length from information_schema.columns where
> table_name='rr' and column_name='data';
>
> Yes?

Yes.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: luca.ciciriello@email.it
Date:
Subject: selective backup and restore
Next
From: Vivek Khera
Date:
Subject: Re: Vacuous errors in pg_dump ... | pg_restore pipeline