From 519ad246ae377bfa2f30a3854545b5c184119b9c Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 13 May 1999 02:35:44 +0000 Subject: [PATCH] Here's a small patch to cause pg_dump to emit the scale and precision for NUMERIC type column defs. Keith Parks --- src/bin/pg_dump/pg_dump.c | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 4ec2171dad..a7b77ef41e 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -21,7 +21,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.105 1999/05/10 00:46:18 momjian Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.106 1999/05/13 02:35:44 momjian Exp $ * * Modifications - 6/10/96 - dave@bensoft.com - version 1.13.dhb * @@ -2671,6 +2671,10 @@ dumpTables(FILE *fout, TableInfo *tblinfo, int numTables, char **parentRels; /* list of names of parent relations */ int numParents; int actual_atts; /* number of attrs in this CREATE statment */ + int32 tmp_typmod; + int precision; + int scale; + /* First - dump SEQUENCEs */ if (tablename) @@ -2749,6 +2753,18 @@ dumpTables(FILE *fout, TableInfo *tblinfo, int numTables, tblinfo[i].atttypmod[j] - VARHDRSZ); } } + else if (!strcmp(tblinfo[i].typnames[j], "numeric")) + { + sprintf(q + strlen(q), "numeric"); + if (tblinfo[i].atttypmod[j] != -1) + { + tmp_typmod = tblinfo[i].atttypmod[j] - VARHDRSZ; + precision = (tmp_typmod >> 16) & 0xffff; + scale = tmp_typmod & 0xffff; + sprintf(q + strlen(q), "(%d,%d)", + precision, scale); + } + } /* char is an internal single-byte data type; * Let's make sure we force it through with quotes. * - thomas 1998-12-13 -- 2.40.0