You want to look at the pg_dump command. A
On Mon, May 14, 2007 at 03:48:17PM -0700, Richard Dunne wrote: > 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 -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
