(8.0.18)
select * from information_schema.innodb_tables;
select * from information_schema.innodb_datafiles;
select * from information_schema.files;
select t1.name,t2.path
from information_schema.innodb_tables t1
inner join information_schema.innodb_datafiles t2
on t1.space = t2.space
order by t1.name
;
select tablespace_name,file_name
from information_schema.files
order by tablespace_name
;
(12cR1)
select * from dba_data_files;
select * from dba_temp_files;
(11)
select schemaname,tablename, pg_relation_filepath(tablename::text)
from pg_tables
where schemaname = 'public'
order by schemaname,tablename
;
(2014)
select * from sys.database_files
;
select file_id, name, type_desc, physical_name, size, max_size
from sys.database_files
;