sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.53k stars 724 forks source link

feature request: Copy row result as sql #649

Open jonaz opened 1 year ago

jonaz commented 1 year ago

For example beeing able to right-click on a row and copy as UPDATE SQL or INSERT SQL would put that row in my clipboard as INSERT INTO X VALUES.....

sosedoff commented 1 year ago

What's the use case?

jonaz commented 1 year ago

The use case is im browsing the data and quickly i want to insert a new row or update the existing one without manually writing a whole query with 30 fields....

http://www.sqldbx.com/ have this feature but its windows ownly.

sosedoff commented 1 year ago

Take a look at https://tableplus.com/ them

jonaz commented 1 year ago

Do you accept a PR or do i have to maintain a fork forever?

sosedoff commented 1 year ago

I do accept PRs, so feel free to take a stab at it.

jonaz commented 1 year ago

@sosedoff opened PR but seems unable to add you as reviewer?

OmlineEditor commented 1 year ago

I am also waiting for this ticket to be updated. I hope they will add and fix the problem soon

jonaz commented 1 year ago

I've not hade the time to update the PR after the comments. Hopefully i get some time next weekend.