filesystem

A file named on its own, with a stem and an extension, or a full Windows path that starts at a drive letter or a network share.

2 filesystem types: none a sibling also accepts, 2 that decompose into parts.

2 types

The 2 filesystem types

Each type's first registry sample, against every sibling's rule

Type	Sample	Also accepted by
Filename filename · VARCHAR	report_final.xlsx	—
Windows File Path windows_path · VARCHAR	C:\Windows\System32\drivers\WdfLdr.sys	—

1 of 2 filesystem types accepts it.

Type	Reads it as
Filename `filename`	report_final.xlsx

Shell

printf '%s\n' 'report_final.xlsx' 'IMG_0042.png' > column.txt
finetype infer -f column.txt --mode column

DuckDB

SELECT ft_profile(v) FROM (VALUES ('report_final.xlsx'), ('IMG_0042.png')) t(v);

After IMG_0042.png, one type remains: filename.