Position(substring in string) int Location of specified substring
postgres=# postgres=# -- position(substring in string) int Location of specified substring postgres=# postgres=# select position('\\000om'::bytea in 'Th\\000omas'::bytea); position ---------- 3 (1 row) postgres=# postgres=#