Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8F49D9FBB9D for ; Mon, 14 May 2007 19:48:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98293-07 for ; Mon, 14 May 2007 19:48:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web50308.mail.re2.yahoo.com (web50308.mail.re2.yahoo.com [206.190.38.62]) by postgresql.org (Postfix) with SMTP id 5D1CB9FB60C for ; Mon, 14 May 2007 19:48:19 -0300 (ADT) Received: (qmail 91900 invoked by uid 60001); 14 May 2007 22:48:17 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=ajdIM4g1WfIIM0xlPrXnkokzE/lETMWs3GmL5S14YxjqbM+aq0gA3wnpKpXxXiSzM9DoGhuFIOlrJYgpaG+vqSYso6S/Txf/lkqlHPKf0qOXirZJrERcaAAVGTNpd/LB/gcWInQKapTqENQQ2fSDq6on1Z4SMyKopwAqWh3U4MI=; X-YMail-OSG: oBAnx64VM1k.QkBgDwz1GhRdRsYYN2RSyG_hUaK_V5yZRtLoSA3huUJm.iQY_7lwm6NTuV6KNbzFRz3A_ZMY5PAct7OgYX2wFO677dhPzvtrRu1GEeQT33pYnN4p.w-- Received: from [85.134.148.231] by web50308.mail.re2.yahoo.com via HTTP; Mon, 14 May 2007 15:48:17 PDT X-Mailer: YahooMailRC/651.23 YahooMailWebService/0.7.41.10 Date: Mon, 14 May 2007 15:48:17 -0700 (PDT) From: Richard Dunne Subject: pg_dump? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Message-ID: <887138.91241.qm@web50308.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/110 X-Sequence-Number: 28390 PostgreSQL begginer. Whats the best way of exporting(dumping) a database/table/view/query to a file? I am using PostgreSQL v 8.2. I am starting postgres server with C:\WINDOWS\system32\net.exe start pgsql-8.2, (start service) C:\postgresql-8.2.3-1\bin\psql.exe -h localhost -p 5432 postgres "Richard" (psql to 'postgres') both of which are run from shortcuts in the start menu. my cli starts with "postgres #", then "databasename #" after connecting using \c. Richard. ____________________________________________________________________________________Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. http://new.toolbar.yahoo.com/toolbar/features/norton/index.php