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