In response to Bart van Houdt : > Hi all, > > I'm trying to write some code to make a 'fingerprint' of a database. This to > compare a customer database with a reference database of our own. > Therefore I'm trying to retrieve information like this: > -Table name > pg_class.relname where relkind = 'r' > -Column name > pg_attribute where attrelid = pg_class.oid > -Data type > pg_type where oid = pg_attribute.atttypid > -Data length > if pg_attribute.atttypmod = -1 then pg_type.typlen > else pg_attribute.atttypmod > -Data precision > No clue > -Nullable > pg_attribute.attnotnull > > As you can see I'm missing the data precision (e.g. numeric (19,2)) and I'm > not > entirely sure about the data length. > > Can anyone tell me where to find the data precision of a column? > And can anyone tell me if I get the data length from the correct places?
information_schema.columns, numeric_precision. http://www.postgresql.org/docs/current/static/infoschema-columns.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
