Thread: External Editor Support

External Editor Support

From
Dave Barter
Date:
We are using pgAdmin a lot for day to day database development and support. JSON is increasingly important to us as the features in 9.3/9.4 make this a dream for DB development.

Editing json fields in pgAdmin is almost unworkable (Mac OSX) and we think that a better option would be to shell out to an external editor. This would make life a lot easier not only for data editing but also for stored procedure development.

Is this on the roadmap at all? If not my company may be willing to do the work if we are pointed at the best way to achieve it.

Thanks
Dave

-- 
Dave Barter

Web: http://www.phased.co.uk
Email:dave@phased.co.uk
Twitter:@Citizenfishy

Re: External Editor Support

From
Guillaume Lelarge
Date:
2014-07-02 10:12 GMT+02:00 Dave Barter <dave.barter@gmail.com>:
We are using pgAdmin a lot for day to day database development and support. JSON is increasingly important to us as the features in 9.3/9.4 make this a dream for DB development.

Editing json fields in pgAdmin is almost unworkable (Mac OSX) and we think that a better option would be to shell out to an external editor. This would make life a lot easier not only for data editing but also for stored procedure development.

Is this on the roadmap at all? If not my company may be willing to do the work if we are pointed at the best way to achieve it.


AFAIK, not at all. But, actually, pgAdmin doesn't seem the best tool to edit data.


--

Re: External Editor Support

From
Dave Page
Date:
On Wed, Jul 2, 2014 at 3:19 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> 2014-07-02 10:12 GMT+02:00 Dave Barter <dave.barter@gmail.com>:
>
>> We are using pgAdmin a lot for day to day database development and
>> support. JSON is increasingly important to us as the features in 9.3/9.4
>> make this a dream for DB development.
>>
>> Editing json fields in pgAdmin is almost unworkable (Mac OSX) and we think
>> that a better option would be to shell out to an external editor. This would
>> make life a lot easier not only for data editing but also for stored
>> procedure development.
>>
>> Is this on the roadmap at all? If not my company may be willing to do the
>> work if we are pointed at the best way to achieve it.
>>
>
> AFAIK, not at all. But, actually, pgAdmin doesn't seem the best tool to edit
> data.

Well, we I have been thinking about an external editor/viewer for blob
data that can be recognised. iirc, the grid control does have the
ability to launch custom editors that could potentially do this.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company