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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings