Thread: editable spreadsheet style interface

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

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 <

> davegauthierpg@

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

> pgsql-general@

> " <

> pgsql-general@

> >
>> *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.