Doubt with output format pgAdmin III

1

my question is this:

There is some way that when generating a query in postgreSql the first row comes out with the following ================, as the following example shows:

  campo1   campo2   campo3   campo4
1 =================================
2  dato1    dato2    dato3    dato4
3  dato5    dato6    dato7    dato8

I am using pgAdmin III, not psql console.

with the following code:

do
$$
declare
r record;
begin
RAISE NOTICE 'nombre1                    nombre2';
RAISE NOTICE '================================';

for r in SELECT upper(nombre1), nombre2
from tabla
order by nombre1 desc loop
raise notice'%', r ;
end loop;
end;
$$ 

I've achieved this:

NOTICE:  nombre1                  nombre2
NOTICE:  ================================
NOTICE:  ("dato1", dato2)
NOTICE:  ("dato3", dato4)
NOTICE:  ("dato5", dato6)
NOTICE:  ("dato7", dato8)

some way to modify the output, that does not come out between quotes "", more separate, more beautiful?

Greetings!

    
asked by GinoGiovanni 27.05.2016 в 05:52
source

0 answers