How to specify a tab in a postgres front-end COPY

you can do this copy cm_state from stdin with (format 'text')

Use E'\t' to tell postgresql there may be escaped characters in there:

\copy cm_state from 'state.data' with delimiter E'\t' null as ';'