Re: Export Tool and Edit grid - Mailing list pgsql-admin

From Vibhor Kumar
Subject Re: Export Tool and Edit grid
Date
Msg-id DE162047-20C7-40EF-9D98-DE5B67508EAE@gmail.com
Whole thread Raw
In response to Export Tool and Edit grid  (Dale Seaburg <kg5lt@verizon.net>)
Responses Re: Export Tool and Edit grid
List pgsql-admin
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
capabilitiesavailable? 


1. launch PGAdmin and connect to the database
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
clickExecute 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
topnavigation 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


pgsql-admin by date:

Previous
From: Dale Seaburg
Date:
Subject: Export Tool and Edit grid
Next
From: Maxim Boguk
Date:
Subject: Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum