Search code examples
postgresqlpgadmin

How do I get query output as text in the pgAdmin v1.14.2 Query Tool?

I seem to remember an option in prior versions of pgAdmin where I could get the results of a query as text (like what one would get using the PSQL console) instead of the graphical "table" view. I cannot find a way to do that now. Any ideas?

Solution

  • There was no such option in pgAdmin for the last ~ 7 years. Disclaimer: I am (low activity nowadays) member of the dev team.

    A quick trick to display a text representation of rows:

    SELECT t::text FROM tbl t;