Questions tagged [postgresql]
The postgresql tag has no usage guidance.
6
questions
3
votes
1
answer
470
views
org babel sql results output in raw form
Is the way to get same output as in terminal with ob-doc-sql.
Executing the sql-query in org will process results into org-table
ignoring other than table information. It doesn't fare well with
...
2
votes
1
answer
2k
views
How to use a hyphenated user-name with postgres in sql-interactive-mode?
I have the following configuration in emacs init files to set a variable (user) to the current Unix login user:
(setq sql-postgres-login-params
`((user :default ,user-login-name)
(...
2
votes
0
answers
174
views
Reference env variable in org babel source block headers
I am setting up an org-mode document to connect to a postgreSQL database and execute+show the results of some queries. I don't want the database password visible in the org document (regardless of ...
1
vote
0
answers
28
views
Is it possible to edit and execute DB stored procedures?
Emacs 27.1
PostgreSQL 9.6
In my java project I use plv8 scripts (stored procedures).
To edit and execute them I use external db client - DBeaver - https://dbeaver.io/
OK - it works just fine. But the ...
1
vote
0
answers
41
views
echo the sql-command after sql-send-region
Currently I can select a region and call sql-send-region, it can be executed well. But if the command needs a long time to run, I am not sure if the command was send or not until the command is ...
0
votes
1
answer
93
views
How to export a PostgreSQL DB model to an org-mode file with tables
Having a PostgreSQL DB model defined in SQL, i would like to generate an org-mode file with a bunch of org mode tables to document it.
So for each CREATE TABLE, it creates an org-mode table with its ...