Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id EF9B81337B96 for ; Tue, 1 Mar 2011 14:31:42 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 31687-09 for ; Tue, 1 Mar 2011 18:31:35 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 483421337B4E for ; Tue, 1 Mar 2011 14:31:35 -0400 (AST) Received: by iwn34 with SMTP id 34so4363663iwn.19 for ; Tue, 01 Mar 2011 10:31:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:mime-version:content-type:from :in-reply-to:date:cc:content-transfer-encoding:message-id:references :to:x-mailer; bh=piqoE4i66CQuxecDt1zAKZWjwYUq1UszdgdL53f+V40=; b=cXjw5K4nx0R6oaM7QYePIgD9t0dPylf3DyeM8lJ0EIU1h8DyWJ+JryNW9YhJIGL1Yc Vr+2A+qKv3Vl22DHsP6d/m4zK1QWBRryhOMsVdMR6kzVXsI/txic9lSlTcnkl2ea9OVh FQiqXqXFWAT0nCfmPAxwg83dgvbj/o5HHA0oQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=OVmzKpVenAJ4biXm/vLdJg37OKaY0fSto7kSY0C/5jbUBZfjzsz5u4lCh580NegJCo WVgCv6wsL/gDPIdSGayyVxk1pXQ/aBrhUCGgEvR/N6FeVryKrA8Qui8q729L1GuNA18X VNT6uDhJnmdk1MybfOm5WBE6GIQxuYJ6AyDg4= Received: by 10.231.157.211 with SMTP id c19mr6598928ibx.172.1299004294900; Tue, 01 Mar 2011 10:31:34 -0800 (PST) Received: from [172.24.35.132] ([121.241.184.140]) by mx.google.com with ESMTPS id d10sm4128227ibb.18.2011.03.01.10.31.31 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 01 Mar 2011 10:31:33 -0800 (PST) Subject: Re: Export Tool and Edit grid Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii From: Vibhor Kumar In-Reply-To: <4D6D2D21.3060405@verizon.net> Date: Wed, 2 Mar 2011 00:02:15 +0530 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <4D6D2D21.3060405@verizon.net> To: Dale Seaburg X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201103/9 X-Sequence-Number: 36881 On Mar 1, 2011, at 11:00 PM, Dale Seaburg wrote: > I have pgAdmin III 1.10.5 working with a 8.4.6 database. Looking at = the pgAdmin III documentation, I see "Export Tool" and Edit Grid" = mentioned, but I do not see either in my copy of pgAdmin III. What do I = have to do to make those capabilities available? 1. launch PGAdmin and connect to the database=20 2. Once connected to the database server and database, launch the SQL = Query window. 3. Now enter the SQL query into the top left box of the Query window, = select Query from the top navigation bar, and click Execute from the = drop down. 3. After executing the query the data will display in the bottom box of = the Query window. 4. Now with the data displayed in the PGAdmin Query window you can = export the data to a CSV file. Select File from the top navigation = window and click on Execute from the drop down. Edit Data. 1. Right Click on table -> view data option. Please note Edit Grid is only for tables which primary key or any = constraint which can uniquely identify each row. Thanks & Regards, Vibhor Kumar vibhor.aim@gmail.com Blog:http://vibhork.blogspot.com