Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE one ();
CREATE TABLE two ();
SELECT *
  FROM information_schema.tables
 WHERE table_schema = ANY (SELECT unnest(string_to_array(replace(setting, '"$user"', CURRENT_USER), ',')) 
                             FROM pg_settings
                            WHERE name = 'search_path');


table_catalog
table_schema
table_name
table_type
self_referencing_column_name
reference_generation
user_defined_type_catalog
user_defined_type_schema
user_defined_type_name
is_insertable_into
is_typed
commit_action


db_302526556
public
one
BASE TABLE
null
null
null
null
null
YES
NO
null

db_302526556
public
two
BASE TABLE
null
null
null
null
null
YES
NO
null

table_catalog	table_schema	table_name	table_type	self_referencing_column_name	reference_generation	user_defined_type_catalog	user_defined_type_schema	user_defined_type_name	is_insertable_into	is_typed	commit_action
db_302526556	public	one	BASE TABLE	null	null	null	null	null	YES	NO	null
db_302526556	public	two	BASE TABLE	null	null	null	null	null	YES	NO	null