selecting tables and columns

Hi does postgresql have a similar command to SHOW in MySQL.
I want to select all tables that match a criteria then select all columns.
from those tables.

in MySQL:  "SHOW tables like 'stu%'";
                   "SHOW columns from ".$tbl." ";
using php variable

thanks
Bob