0

When I use \d command, psql displays tables for me on the current screen. Then I can input my next command on the same screen.

But, select is different. Issue the command: select * from mytable, psql displays the result on another screen. I have to press q to quit it and return to command line screen.

I want to select command to display the result on the same screen in command line. How can I do it? Thanks.

Improve this question
5
  • 2
    Can you describe a little bit more? trying to understand your problem, what's the printing difference between \d and select? Commented Dec 6, 2019 at 4:25
  • Is there anything weird in your .psqlrc file? Commented Dec 6, 2019 at 6:48
  • Are you talking about the pager, rather than the editor? You can \pset pager off if you want the results sent to a pager, like "more" or "less". Commented Dec 6, 2019 at 22:48
  • Thanks, I changed the description to make it clearer. Sorry for the confusing. Commented Dec 7, 2019 at 11:44
  • @jjanes You should answer with that "\pset pager off detail", I think that is the correct answer Commented Feb 14, 2023 at 19:54
Related questions
1975
How to exit from PostgreSQL command line utility: psql
828
Run a PostgreSQL .sql file using command line arguments
511
Run PostgreSQL queries from the command line
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.