pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedExport Tool and Edit grid
3+ messages / 2 participants
[nested] [flat]
* Export Tool and Edit grid
@ 2011-03-01 17:30 Dale Seaburg <kg5lt@verizon.net>
2011-03-01 18:32 ` Re: Export Tool and Edit grid Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Dale Seaburg @ 2011-03-01 17:30 UTC (permalink / raw)
To: pgsql-admin
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?
Dale.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Export Tool and Edit grid
2011-03-01 17:30 Export Tool and Edit grid Dale Seaburg <kg5lt@verizon.net>
@ 2011-03-01 18:32 ` Vibhor Kumar <vibhor.aim@gmail.com>
2011-03-01 22:23 ` Re: Export Tool and Edit grid Dale Seaburg <kg5lt@verizon.net>
0 siblings, 1 reply; 3+ messages in thread
From: Vibhor Kumar @ 2011-03-01 18:32 UTC (permalink / raw)
To: Dale Seaburg <kg5lt@verizon.net>; +Cc: 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 capabilities available?
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 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Export Tool and Edit grid
2011-03-01 17:30 Export Tool and Edit grid Dale Seaburg <kg5lt@verizon.net>
2011-03-01 18:32 ` Re: Export Tool and Edit grid Vibhor Kumar <vibhor.aim@gmail.com>
@ 2011-03-01 22:23 ` Dale Seaburg <kg5lt@verizon.net>
0 siblings, 0 replies; 3+ messages in thread
From: Dale Seaburg @ 2011-03-01 22:23 UTC (permalink / raw)
To: Vibhor Kumar <vibhor.aim@gmail.com>; +Cc: pgsql-admin
On 3/1/2011 12:32 PM, Vibhor Kumar wrote:
> 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
> 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
>
>
Vibhor,
Thank you for the quick and accurate response. I did not recognize the
View Data to be the "Edit Grid". I have used the View Data on several
occasions. OTOH, the Export was well hidden within the File menu of the
Query Tool. Very good! The documentation probably should point this
out. The doc's was not crystal clear how to get to the Export option.
Again, thanks for the insight with regards to Exporting, and refresher
of the View Data (Edit grid).
Dale.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-03-01 22:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-03-01 17:30 Export Tool and Edit grid Dale Seaburg <kg5lt@verizon.net>
2011-03-01 18:32 ` Vibhor Kumar <vibhor.aim@gmail.com>
2011-03-01 22:23 ` Dale Seaburg <kg5lt@verizon.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox