I have installed PostgreSQL and it is working ok. However, when I went to restore a backup I got the开发者_StackOverflow社区 error -bash: psql: command not found:
Rather than apply a \\set HISTFILE command for every possible connection, we would like to have no .psql_history at all.However, psql seems to dislike that:
I am trying to automate database creation process with a shell script and one thing I\'ve hit a road block with passing a password to psql.
Okay, I appreciate that the question is a tad vague, but after a day of googling, I\'m getting nowhere, any help will be appreciated, and I\'m willing to try anything.
I\'m using psql\'s \\dt to list all 开发者_运维问答tables in a database and I need to save the results.
I have Django application which needs to call psql. I do this in a celery thread which looks like this:
I have a (production) DB server running PostgreSQL v9.0 and a development machine running PostgreSQL v8.4. I would like to take a dump of the production DB and use it开发者_如何学Go on the development
Is there a way to specify that when executing a sql script it stops when encounterin开发者_运维知识库g the first error on the script, it usually continues, regardless of previous errors.I think the so
I\'m currently using emacs sql-mode as my sql shell, a (simplified) query response is below: my_db=# select * from visit limit 4;
In MySQL, I开发者_如何学Python used use database_name; What\'s the psql equivalent?In PostgreSQL, you can use the \\connect meta-command of the client tool psql: