editable spreadsheet style interface

I have used Aqua Data Studio for several years. Jetbrains recently released a similar product. Academic licensing is affordable (~ $200 a year) and very cheap if considered in terms of the time it saves you.

From: David Gauthier <davegauthierpg@gmail.com>
Date: Tuesday, October 30, 2018 at 2:06 PM
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: editable spreadsheet style interface

I think I know the answer to this one but I'll ask anyway...

Is there a spreadsheet style interface to a PG DB where users can...
- lock records
- edit records
- submit changes (transaction)

Is there any after-market tool for PG that does something like this ?

On 30/10/2018 20:32, Martin Mueller wrote:

I have used Aqua Data Studio for several years. Jetbrains recently
released a similar product. Academic licensing is affordable (~ $200 a
year) and very cheap if considered in terms of the time it saves you.

*From: *David Gauthier <davegauthierpg@gmail.com>
*Date: *Tuesday, October 30, 2018 at 2:06 PM
*To: *"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
*Subject: *editable spreadsheet style interface

I think I know the answer to this one but I'll ask anyway...

Is there a spreadsheet style interface to a PG DB where users can...

- lock records

- edit records

- submit changes (transaction)

Is there any after-market tool for PG that does something like this ?

Have a look here https://www.postgresql.org/download/product-categories/
under "Administration/Development". I'm using pgAdmin right now.

Tim Clarke

For a quick and dirty data editor, LibreOffice Base seems to work fine.

On Tue, 30 Oct 2018 at 23:05, Tim Clarke <tim.clarke@minerva-analytics.info>
wrote:

Tim Clarke-2 wrote

On 30/10/2018 20:32, Martin Mueller wrote:

I have used Aqua Data Studio for several years. Jetbrains recently
released a similar product. Academic licensing is affordable (~ $200 a
year) and very cheap if considered in terms of the time it saves you.

*From: *David Gauthier &lt;

davegauthierpg@

&gt;

*Date: *Tuesday, October 30, 2018 at 2:06 PM
*To: *"

pgsql-general@

" &lt;

pgsql-general@

&gt;

*Subject: *editable spreadsheet style interface

I think I know the answer to this one but I'll ask anyway...

Is there a spreadsheet style interface to a PG DB where users can...

- lock records

- edit records

- submit changes (transaction)

Is there any after-market tool for PG that does something like this ?

Have a look here https://www.postgresql.org/download/product-categories/
under "Administration/Development". I'm using pgAdmin right now.

Tim Clarke

SQLeo http://sqleo.sourceforge.net/index.html is in that list (free), and
can
- insert, update, delete records,
- choose the update, delete key (if no pk),
- view the changes in sql format,
- apply to db,
- commit or rollback (if not in auto-commit mode)

(without locking)

see
http://sqleo.sourceforge.net/guide/English_SQLeo_AdvancedHelp.htm#_Toc467095120

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

I can second this as an option. We’ve done some editing with Libre office as well in Postgres.

bobb

On Oct 31, 2018, at 5:01 AM, Tony Shelver <tshelver@gmail.com<mailto:tshelver@gmail.com>> wrote:

For a quick and dirty data editor, LibreOffice Base seems to work fine.

On Tue, 30 Oct 2018 at 23:05, Tim Clarke <tim.clarke@minerva-analytics.info<mailto:tim.clarke@minerva-analytics.info>> wrote:
On 30/10/2018 20:32, Martin Mueller wrote:

I have used Aqua Data Studio for several years. Jetbrains recently
released a similar product. Academic licensing is affordable (~ $200 a
year) and very cheap if considered in terms of the time it saves you.

*From: *David Gauthier <davegauthierpg@gmail.com<mailto:davegauthierpg@gmail.com>>
*Date: *Tuesday, October 30, 2018 at 2:06 PM
*To: *"pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>" <pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>>
*Subject: *editable spreadsheet style interface

I think I know the answer to this one but I'll ask anyway...

Is there a spreadsheet style interface to a PG DB where users can...

- lock records

- edit records

- submit changes (transaction)

Is there any after-market tool for PG that does something like this ?

Have a look here https://www.postgresql.org/download/product-categories/
under "Administration/Development". I'm using pgAdmin right now.

Tim Clarke

"He who hesitates is a damned fool."
- Mae West