some psql commands, such as \COPY, aren't working.

[tmthyjames]

[tmthyjames]

commands like \COPY are resolved by:

output = subprocess.check_output(pg)
if '<table border=' not in output:
    return output

commands like \connect are resolved by passing multiple commands separated by the -c option:

psql database -c "\connect some_database" -c "select * from table limit 10;"

See this.

[tmthyjames]

Not closing just yet. Will test other commands.