The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
14 views

psql ignores my PAGER variable

I want to use less as my default pager. Therefore I have PAGER=less in my .bashrc. It's sourced properly: $ echo $PAGER less However, psql still uses more if I call it with psql. BUT: If I call it ...
1
vote
1answer
17 views

How to display server name in psql prompt

I have two servers running same PostgreSQL databases where one is production and one is development snapshot. It would be very handy for me if I could show the server name in the psql prompt (like ...
1
vote
0answers
350 views

Postgresql query within a bash script

We are having an issue with a postgresql bash query. The output of the query from the bash script add's additional quotes around the date. Please can you help me fix it?! Script: #!/bin/sh ...
0
votes
1answer
29 views

Change how PSQL shows queries

This is a minor issue, but it's driving me nuts. Anyways, on some of my servers I'm running PostgreSQL 8.4. When using PSQL (also 8.4), queries are shown with a less-like interface, which I'm quite ...
0
votes
1answer
82 views

How to change output pattern in shell?

I run the psql command from a Linux shell. The resulting output looks like a table: Name Age ----------------- John 24 But I would like to get the result with commas like ...
2
votes
1answer
571 views

(-bash: initdb: command not found) When installing postgres mac

I get the following error (-bash: initdb: command not found) in the terminal when trying to install postgres on my mountain lion mac osx? Also, does any one have a good resource for installing ...
4
votes
2answers
1k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...