Tag Info

New answers tagged

0

If you have many request and some semicolons use Transaction : In psql open editor mode \e: -- at start of edited text BEGIN TRANSACTION; -- ... your requests here -- save exit Back to psql : your requests are executed but change are not written : If all is OK, save changes with : COMMIT; else If you have errors or want to cancel : ROLLBACK;


2

First of all, this is an error message from PostgreSQL, which is not the same as psql (the command-line client). The SET command sets run-time parameters of the Postgres server, which is completely independent from the client (psql in this case). Either way, it works for me. Testing the standard distribution of Postgres 9.4.1 on a Windows client set to a ...


1

I'm afraid it's not possible - at least according to the documentation Check this out here. To enable messages to be translated to the user's preferred language, NLS must have been selected at build time (configure --enable-nls). All other locale support is built in automatically. You have to configure the database when you install it. Is your ...


2

I need to press the q key as required by less or man for the execution to finish and return to the command prompt? Sounds like your terminal's pager is taking over the output: you can tell psql not to send its output to the pager when you're using the -c 'select... ' invocation via: psql --pset pager=off -d database -c 'SELECT * from TABLE' You may ...


0

A conversation about this on GitHub led to an interim "quick fix" solution: open ~/.editrc and add: bind "^R" em-inc-search-prev Apparently the bigger issue is that PostgresApp uses libedit instead of libreadline. And supposedly libedit lacks some command-line features of libreadline, so until PostgresApp is compiled against libreadline, just use ...



Top 50 recent answers are included