RE: How to double-quote a double quoted identifier?

2020-06-15 Thread Edson Richter
De: Tom Lane Enviado: segunda-feira, 15 de junho de 2020 22:24 Para: Edson Richter Cc: pgsql-general Assunto: Re: How to double-quote a double quoted identifier? Edson Richter writes: > How do I remote execute que following command: > CREATE EXTENSION "uuid-ossp" >

Re: How to double-quote a double quoted identifier?

2020-06-15 Thread Tom Lane
Edson Richter writes: > 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

How to double-quote a double quoted identifier?

2020-06-15 Thread Edson Richter
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 "