Обсуждение: how to take a single table data backup in postgres 7.2.3 database.?

Hi ,

I would appreciate if some one could help me how to take a single table back up in postgres 7.2.3.

Thanks in Advance.



Regards,
Somasekhar Bangalore
Principal Software Engineer
ZenSutra Software Technologies Pvt. Ltd.
Suite 601, HM Geneva House
#14, Cunningham Road
Bangalore 560-052, India

Ph:+91-80-235-0481
Fax:+91-80-235-0486
Email: sbangalore@zensutra.com

Weaving the knowledge tapestry'

On Thursday 25 September 2003 12:01, you wrote:
> Hi ,
>
> I would appreciate if some one could help me how to take a sin


pg_dump -t tablename dbname

> I would appreciate if some one could help me how to take a single table
> back up in postgres 7.2.3.

$ pg_dump -h hostname dbname -t tablename -uf filename.sql

regards,
bhuvaneswaran