66 * Portions Copyright (c) 1994, Regents of the University of California
77 *
88 *
9- * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.72 2006/03/05 15:58:51 momjian Exp $
9+ * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.73 2006/03/30 01:08:15 adunstan Exp $
1010 *
1111 *-------------------------------------------------------------------------
1212 */
@@ -444,7 +444,7 @@ dumpRoles(PGconn *conn)
444444"true as rolcanlogin, "
445445"-1 as rolconnlimit, "
446446"passwd as rolpassword, "
447- "valuntil as rolvaliduntil "
447+ "valuntil as rolvaliduntil, "
448448"null as rolcomment "
449449"FROM pg_shadow "
450450"UNION ALL "
@@ -457,8 +457,8 @@ dumpRoles(PGconn *conn)
457457"false as rolcanlogin, "
458458"-1 as rolconnlimit, "
459459"null::text as rolpassword, "
460- "null::abstime as rolvaliduntil "
461- "null "
460+ "null::abstime as rolvaliduntil, "
461+ "nullas rolcomment "
462462"FROM pg_group" );
463463
464464res = executeQuery (conn ,buf -> data );