You can try pg_dump -U postgres -d -O databasename > databasename.sql
Thanks, Richard Sitompul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gourish Singbal Sent: Tuesday, March 01, 2005 14:37 To: PgSQL Admin Subject: [ADMIN] Whats the file extention for custom format in pg_dump can someone tell me the default file compression type for dumps taken using /usr/local/pgsql/bin/pg_dump -b -F c -h <host> -d <database> please any help would be great -- Best, Gourish Singbal ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
