? logfile
? psql
Index: describe.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/bin/psql/describe.c,v
retrieving revision 1.199
diff -c -r1.199 describe.c
*** describe.c	11 Feb 2009 19:12:04 -0000	1.199
--- describe.c	25 Feb 2009 22:53:50 -0000
***************
*** 1668,1673 ****
--- 1668,1699 ----
  		}
  		PQclear(result);
  
+  		/* print child tables */
+ 		printfPQExpBuffer(&buf, "SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s'  ORDER BY i.inhseqno;", oid);
+ 
+                 result = PSQLexec(buf.data, false);
+                 if (!result)
+                         goto error_return;
+                 else
+                         tuples = PQntuples(result);
+ 
+                 for (i = 0; i < tuples; i++)
+                 {
+                         const char *s = _("Child tables");
+ 
+                         if (i == 0)
+                                 printfPQExpBuffer(&buf, "%s: %s", s, PQgetvalue(result, i, 0));
+                         else
+                                 printfPQExpBuffer(&buf, "%*s  %s", (int) strlen(s), "", PQgetvalue(result, i, 0));
+                         if (i < tuples - 1)
+                                 appendPQExpBuffer(&buf, ",");
+ 
+                         printTableAddFooter(&cont, buf.data);
+                 }
+                 PQclear(result);
+ 
+ 
+ 
  		if (verbose)
  		{
  			const char *s = _("Has OIDs");