How to re-run a query?

[usli06]

Hi all,

In vsql how can I re-run a query with out typing it again? Is the query stored in a buffer like in sql*plus in Oracle?

Thanks!

[rajasekhart]

Hi,

I think you dont need to retype it again. just click on up arrow key. It will appear and u can run it.
Let me know if it works.

Thanks,
Raj.

[JimKnicely]

Hi,

The up arrow only repeats the last line entered. I think usli06 wants to re-send the entire buffer for execution.

The \g meta-command can be used to send query buffer to the server:

Example:

Code: Select all

dbadmin=> select count(*)
dbadmin->   from test1
dbadmin->   join test2 on test2.col2 = test1.col1;
 count
-------
     1
(1 row)

dbadmin=> \g
 count
-------
     1
(1 row)

[rajasekhart]

Hi Jim,

Today i learned a new command. Thanks for the info.

Raj.

[usli06]

Thanks, guys! This was what I needed!

[jpcavanaugh]

In addition to this, \s will show you the history of the commands that you have run and you can cut/paste to run previous queries.