Обсуждение: 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 ?
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:
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.
bobb
On Oct 31, 2018, at 5:01 AM, Tony Shelver <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> 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>
> *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
- "He who hesitates is a damned fool."
- - Mae West