Questions tagged [postgresql]
5 questions
3
votes
1 answer
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
multiple query in the block as show below will squash…
rho
- 243
- 2
- 10
2
votes
0 answers
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 whether the document is exported: I want to be able…
dlid
- 121
- 5
2
votes
1 answer
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)
(database :default ,user-login-name)
(server…
tinlyx
- 1,276
- 1
- 12
- 27
1
vote
0 answers
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 question is:
Is it possible to edit and execute…
a_subscriber
- 3,854
- 1
- 17
- 47
1
vote
0 answers
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 completed.
so do we have a method to show the command I…
zhihuifan
- 165
- 4