Re: editable spreadsheet style interface

From: "Basques, Bob (CI-StPaul)" <bob(dot)basques(at)ci(dot)stpaul(dot)mn(dot)us>
To: Tony Shelver <tshelver(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: editable spreadsheet style interface
Date: 2018-10-31 14:17:24
Message-ID: 2F60BC8B-D0DA-45C7-A49E-961EE1B5F514@ci.stpaul.mn.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com<mailto:tshelver(at)gmail(dot)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(dot)clarke(at)minerva-analytics(dot)info<mailto:tim(dot)clarke(at)minerva-analytics(dot)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(at)gmail(dot)com<mailto:davegauthierpg(at)gmail(dot)com>>
> *Date: *Tuesday, October 30, 2018 at 2:06 PM
> *To: *"pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>" <pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2018-10-31 15:25:34 Re: Is there a way to speed up WAL replay?
Previous Message Szymon Lipiński 2018-10-31 14:09:48 Re: bug in autovacuum_analyze_scale_factor meta data