| From: | Richard Dunne <richarddunne1971(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | pg_dump? |
| Date: | 2007-05-14 22:48:17 |
| Message-ID: | 887138.91241.qm@web50308.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 rest assured with the added security of spyware protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryce Nesbitt | 2007-05-14 22:55:45 | Doing a conditional aggregate (e.g. count(*) if x=y) in postgres? |
| Previous Message | Rodrigo De León | 2007-05-14 20:12:18 | Re: How to retrieve a n-ary tree in SQL? |