Skip to main content



      Home
Home » Eclipse Projects » DTP » How to submit SQL queries?
How to submit SQL queries? [message #15731] Thu, 01 June 2006 02:15 Go to next message
Eclipse UserFriend
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 17: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 17:12 Go to previous message
Eclipse UserFriend
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: Sat Jul 12 20:25:28 EDT 2025

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

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

Back to the top