How to double-quote a double quoted identifier?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to double-quote a double quoted identifier?
Date: 2020-06-16 00:52:08
Message-ID: DM6PR13MB39880CD8E721A9A0C23EB76FCF9D0@DM6PR13MB3988.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-16 01:24:40 Re: How to double-quote a double quoted identifier?
Previous Message Peter 2020-06-15 22:28:16 Re: Something else about Redo Logs disappearing