Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to submit SQL queries?
How to submit SQL queries? [message #15731] Thu, 01 June 2006 06:15 Go to next message
Juergen Zimmermann is currently offline Juergen ZimmermannFriend
Messages: 21
Registered: July 2009
Junior Member
I just installed version 0.9RC4. The "Database Development" perspective
looks fine. Using PostgreSQL 8.1.4 I can browse my schema, tables, columns.

How can I inspect the data records in the tables?
How can I submit an SQL query?
Re: How to submit SQL queries? [message #17072 is a reply to message #15731] Wed, 14 June 2006 21:12 Go to previous message
Eclipse UserFriend
Originally posted by: jograham.sybase.com

Juergen Zimmermann wrote:

> I just installed version 0.9RC4. The "Database Development" perspective
> looks fine. Using PostgreSQL 8.1.4 I can browse my schema, tables, columns.

> How can I inspect the data records in the tables?
> How can I submit an SQL query?

Hi Juergen:

Once BZ#146919 (https://bugs.eclipse.org/bugs/show_bug.cgi?id=146919) is
verified (looking for this week), you will be able to create New->SQL
Development->SQL File and then "Set Connection Information" to your
PostgreSQL db. From there, you can type in SQL statements and see the
results in the SQL Results view. This includes data in tables, and will
work the same way as it does for the Apache Derby example detailed in:

http://wiki.eclipse.org/index.php/Getting_Started_with_DTP

In the future we expect to work on a more convenient way of browsing table
data through an Eclipse view.

HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: How to submit SQL queries? [message #579648 is a reply to message #15731] Wed, 14 June 2006 21:12 Go to previous message
John Graham is currently offline John GrahamFriend
Messages: 183
Registered: July 2009
Senior Member
Juergen Zimmermann wrote:

> I just installed version 0.9RC4. The "Database Development" perspective
> looks fine. Using PostgreSQL 8.1.4 I can browse my schema, tables, columns.

> How can I inspect the data records in the tables?
> How can I submit an SQL query?

Hi Juergen:

Once BZ#146919 (https://bugs.eclipse.org/bugs/show_bug.cgi?id=146919) is
verified (looking for this week), you will be able to create New->SQL
Development->SQL File and then "Set Connection Information" to your
PostgreSQL db. From there, you can type in SQL statements and see the
results in the SQL Results view. This includes data in tables, and will
work the same way as it does for the Apache Derby example detailed in:

http://wiki.eclipse.org/index.php/Getting_Started_with_DTP

In the future we expect to work on a more convenient way of browsing table
data through an Eclipse view.

HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
Previous Topic:Database Explorer doesn't show schemas content for Oracle 9i
Next Topic:BIRT 2.1.0 distribution missing some plugin metadata?
Goto Forum:
  


Current Time: Fri Apr 19 04:45:23 GMT 2024

Powered by FUDForum. Page generated in 0.01873 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top