Miles Keaton <mileskeaton@xxxxxxxxx> writes: > pg_dump does not include ALTER DATABASE ... SET search_path TO ... > pg_dumpall does include it. This is per design; it holds for all ALTER DATABASE properties not just search_path. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org