How to double-quote a double quoted identifier? - Mailing list pgsql-general

From Edson Richter
Subject How to double-quote a double quoted identifier?
Date
Msg-id DM6PR13MB39880CD8E721A9A0C23EB76FCF9D0@DM6PR13MB3988.namprd13.prod.outlook.com
Whole thread Raw
Responses Re: How to double-quote a double quoted identifier?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter
Date:
Subject: Re: Something else about Redo Logs disappearing
Next
From: Tom Lane
Date:
Subject: Re: How to double-quote a double quoted identifier?