Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 0FA991336FA7
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 27 Sep 2010 08:31:39 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 67424-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 27 Sep 2010 11:31:32 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from exprod7og104.obsmtp.com (exprod7og104.obsmtp.com [64.18.2.161])
	by mail.postgresql.org (Postfix) with SMTP id 8AE9D1337999
	for <pgsql-sql@postgresql.org>; Mon, 27 Sep 2010 08:31:31 -0300 (ADT)
Received: from source ([209.85.212.181]) by exprod7ob104.postini.com
	([64.18.6.12]) with SMTP
	ID DSNKTKCAk5BI7JpNhDTeAayLMywVX1wZ8Pi3@postini.com;
	Mon, 27 Sep 2010 04:31:32 PDT
Received: by pxi5 with SMTP id 5so1453195pxi.12
	for <pgsql-sql@postgresql.org>; Mon, 27 Sep 2010 04:31:31 -0700 (PDT)
Received: by 10.142.226.8 with SMTP id y8mr6277872wfg.14.1285587085977;
	Mon, 27 Sep 2010 04:31:25 -0700 (PDT)
Received: from [192.168.1.2] ([122.170.48.126])
	by mx.google.com with ESMTPS id c14sm7278404wfe.14.2010.09.27.04.31.22
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Mon, 27 Sep 2010 04:31:24 -0700 (PDT)
Subject: Re: pgdump with insert command help
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.kumar@enterprisedb.com>
In-Reply-To: <AANLkTimdTxz0yZxKPden=wSh0KnCJJMdoocuVMK4DGK7@mail.gmail.com>
Date: Mon, 27 Sep 2010 17:01:18 +0530
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <BDFF6AB4-0E61-47DB-BFBA-04C022D36F00@enterprisedb.com>
References: <AANLkTimdTxz0yZxKPden=wSh0KnCJJMdoocuVMK4DGK7@mail.gmail.com>
To: Nicholas I <nicholas.domnic.i@gmail.com>
X-Mailer: Apple Mail (2.1081)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-3.43 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_SORBS_WEB=0.77
X-Spam-Level: 
X-Archive-Number: 201009/106
X-Sequence-Number: 34637


On Sep 24, 2010, at 6:02 PM, Nicholas I wrote:

> 
> pg_dump -Dt --insert table dbname > table.sql;
> 
> i am not able to get the output. is this correct ?

Try following:
pg_dump --insert -t <tablename> <dbname> 

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation