Alternate output format for psql showing one column per line with column name

by

I just needed to spend more time staring at the documentation. This command:

\x on

will do exactly what I wanted. Here is some sample output:

select * from dda where u_id=24 and dda_is_deleted='f';
-[ RECORD 1 ]------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
dda_id             | 1121
u_id               | 24
ab_id              | 10304
dda_type           | CHECKING
dda_status         | PENDING_VERIFICATION
dda_is_deleted     | f
dda_verify_op_id   | 44938
version            | 2
created            | 2012-03-06 21:37:50.585845
modified           | 2012-03-06 21:37:50.593425
c_id               | 
dda_nickname       | 
dda_account_name   | 
cu_id              | 1
abd_id             |

See also:

More Related Contents:

  1. PostgreSQL “DESCRIBE TABLE”
  2. How to exit from PostgreSQL command line utility: psql
  3. In psql, why do some commands have no effect?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. Run batch file with psql command without password
  6. Run a PostgreSQL .sql file using command line arguments
  7. How to switch databases in psql?
  8. Postgresql: Scripting psql execution with password
  9. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  10. psql: FATAL: database “” does not exist
  11. PostgreSQL: Why psql can’t connect to server?
  12. Use variable set by psql meta-command inside of DO block
  13. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  14. PostgreSQL disable more output
  15. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  16. How to do an update + join in PostgreSQL?
  17. Store common query as column?
  18. How does PostgreSQL enforce the UNIQUE constraint / what type of index does it use?
  19. How to convert primary key from integer to serial?
  20. How to drop a PostgreSQL database if there are active connections to it?
  21. postgresql duplicate key violates unique constraint
  22. gem install pg –with-pg-config works, bundle fails
  23. Unable to connect PostgreSQL to remote database using pgAdmin
  24. Postgres JSON data type Rails query
  25. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  26. how to store PostgreSQL jsonb using SpringBoot + JPA?
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment