Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2JGQL345758 for ; Mon, 19 Mar 2001 11:26:21 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2JGNnt19711; Mon, 19 Mar 2001 11:23:49 -0500 (EST) To: "Josh Berkus" cc: pgsql-sql@postgresql.org Subject: Re: What do I do with this error? In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Mon, 19 Mar 2001 08:05:41 -0800" Date: Mon, 19 Mar 2001 11:23:49 -0500 Message-ID: <19708.985019029@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/360 X-Sequence-Number: 2024 "Josh Berkus" writes: > Can either of you supply me with syntax to pg_dump the full function & > view decarations to a text file? If you're sure it doesn't require any data, you can do "pg_dump -s dbname" to get just the database schema. I'd start with that and then trim away unrelated stuff, if you feel the urge to trim. regards, tom lane