How do I remote execute que following command:

CREATE EXTENSION "uuid-ossp"
    SCHEMA public
    VERSION "1.1";

I'm using PostgreSQL 9.6, Linux x64, and bash.

I've tried the following:

ssh -l postgres -2 -C -p 2022 192.168.0.70 "psql -h 127.0.0.1 -d test_db -p 
5432 -c \"CREATE EXTENSION \\\\""uuid-ossp\\\\"" SCHEMA pg_catalog;\" "

I know this is a kind of "bash-psql" issue, but I would appreciate if anyone 
could share experience with this.

Thanks a lot,

Edson

Reply via email to