From cf3cc7576c1ef388534c5994f29a6335e00a5c71 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 9 Aug 2003 01:21:54 +0000 Subject: [PATCH] This makes psql use the new pg_get_viewdef function. It also puts one extra line break in to improve formatting. Christopher Kings-Lynne --- src/bin/psql/describe.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c index 080f299f1a..188cc3adf3 100644 --- a/src/bin/psql/describe.c +++ b/src/bin/psql/describe.c @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2003, PostgreSQL Global Development Group * - * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.83 2003/08/04 23:59:40 tgl Exp $ + * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.84 2003/08/09 01:21:54 momjian Exp $ */ #include "postgres_fe.h" #include "describe.h" @@ -746,7 +746,7 @@ describeOneTableDetails(const char *schemaname, { PGresult *result; - printfPQExpBuffer(&buf, "SELECT pg_catalog.pg_get_viewdef('%s'::pg_catalog.oid)", oid); + printfPQExpBuffer(&buf, "SELECT pg_catalog.pg_get_viewdef('%s'::pg_catalog.oid, true)", oid); result = PSQLexec(buf.data, false); if (!result) goto error_return; @@ -926,7 +926,7 @@ describeOneTableDetails(const char *schemaname, footers = xmalloczero((rule_count + 2) * sizeof(*footers)); footers[count_footers] = xmalloc(64 + strlen(view_def)); snprintf(footers[count_footers], 64 + strlen(view_def), - _("View definition: %s"), view_def); + _("View definition:\n%s"), view_def); count_footers++; /* print rules */ -- 2.11.0