psql
Postgresql -bash: psql: command not found
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:[详细]
2023-03-22 10:30 分类：问答PostgreSQL: .psql_history to /dev/null
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:[详细]
2023-03-19 05:45 分类：问答How do I specify a password to 'psql' non-interactively?
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.[详细]
2023-03-14 11:38 分类：问答PSQL = fast, remote sql = v.slow
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.[详细]
2023-02-19 06:30 分类：问答psql - save results of command to a file
I\'m using psql\'s \\dt to list all 开发者_运维问答tables in a database and I need to save the results.[详细]
2023-02-17 19:25 分类：问答subprocess.popen and psql
I have Django application which needs to call psql. I do this in a celery thread which looks like this:[详细]
2023-02-11 02:14 分类：问答Use pg_restore to restore from a newer version of PostgreSQL
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[详细]
2023-02-02 05:29 分类：问答How can I stop a Postgres script when it encounters an error?
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[详细]
2023-01-31 10:50 分类：问答Homoiconicity and SQL
I\'m currently using emacs sql-mode as my sql shell, a (simplified) query response is below: my_db=# select * from visit limit 4;[详细]
2023-01-26 12:00 分类：问答How to switch databases in psql?
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:[详细]
2023-01-20 14:58 分类：问答
加载中,请稍侯......