Extract especific text from a sql statement

[Emanuel Araújo <eacshm@xxxxxxxxx>]

Hi,

I need help to extract fields and tables from a sql statement.

Example:

SELECT pc.cod, pc.val, pi.qtd,

COALESCE(pc.name, 'empty') AS name, lower(coalesce(pc.email, 'empty')) as email,

status

FROM pc

INNER JOIN pi on (pc.cod = pi.cod)

WHERE pc.startdate > CURRENT_DATE

order by 1 desc

;

I need to return that:

pc.cod

pc.val

pi.qtd

pc.name

pc.email

status

pc

pi

pc.startdate

can you help me ?

--

Atenciosamente,

Emanuel Araújo