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
|