Formattazione output query

Eseguendo query da riga di comando con psql per formattare l’output usare il comando \x on

DEPOSITO=# \x on
Expanded display is on.
DEPOSITO=# select * from “grant” where user_id = 2;
-[ RECORD 1 ]———————————————————————————————-
id | 17
user_id | 2
status | draft
permission | documents.read
description | prova dal 06/10/2021 al 09/10/2021 per il documento: 002.REGISTRO UFFICIALE.2020.0000001.pdf.
begins_at |
expires_at |
created_at | 2021-10-06 16:05:02.699706+02
updated_at | 2021-10-06 16:05:02.717+02
author_id | 1
deleted_at |
approved_at |
declined_at |
area_uid | 002

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *