:tables method in PostgreSQL respects the schema parameter

When the 'schema' param is supplied, the method should only fetch
tables from that schema (param was previously defined as 'name'
and was not used in the method). Otherwise, it should fetch all tables
from the current search path.