\x
select * from table_name;

this will display each record individually, where the column labels become the row labels