Feature request: export psql-like pretty text (including query) that I can paste into Slack/email/etc
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
I end up taking a LOT of screenshots of Postico and pasting them into Slack. Usually the conversation goes: "something doesn't look right in the database. Look at the weirdness this query returns." Then I paste in a screenshot of the query editor and response from Postico. That's a pain because someone can't easily copy-paste my query, and the results are also not searchable.
On some occasions, I have tried to "roll my own" version of this feature request by copy-pasting the query out of the query editor as text then also "Copy Special > Copy with header" from the response. This works ok, and at least all of the text is there in a searchable way, but the formatting looks very ugly.
## Bad copy paste of image, but what I usually do:

## Better, but cumbersome and still doesn't look very nice:
```
SELECT 'postico should copy/paste like psql' AS my_request,
'wow great feature request idea' AS postico_response;
my_request postico_response
postico should copy/paste like psql wow great feature request idea
```

### What I am requesting
I can "Copy Special > Pretty Text" and get something like this on my clipboard that I can paste into Slack or email
```
SELECT 'postico should copy/paste like psql' AS my_request,
'wow great feature request idea' AS postico_response;
My Request | Postico Response
-------------------------------------+---------------------------------
postico should copy/paste like psql | wow great feature request idea
(1 row)
```
Contributor guide
No contributing guide indexed for this repository
Research direction
No files or tests are identified in the issue. Start by locating the query editor and response copy actions, then compare their current clipboard formats with the requested psql-like output. Done means a Pretty Text copy option includes the query and formatted results, including headers and row count, in pasteable plain text.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100