Questions tagged [postgresql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
11 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 ...
user avatar
  • 3,435
0 votes
0 answers
19 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 ...
user avatar
  • 101
3 votes
1 answer
144 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 ...
user avatar
  • 243
1 vote
0 answers
31 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 ...
user avatar
  • 165
1 vote
1 answer
1k 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) (...
user avatar
  • 912