pg_dump? - Mailing list pgsql-sql

From Richard Dunne
Subject pg_dump?
Date
Msg-id 887138.91241.qm@web50308.mail.re2.yahoo.com
Whole thread Raw
Responses Re: pg_dump?  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Re: pg_dump?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
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
restassured with the added security of spyware protection.
 
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php


pgsql-sql by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: How to retrieve a n-ary tree in SQL?
Next
From: Bryce Nesbitt
Date:
Subject: Doing a conditional aggregate (e.g. count(*) if x=y) in postgres?