| 27 | |
| 28 | An even more convoluted case (might be better as it covers a few more edge cases): |
| 29 | |
| 30 | {{{ |
| 31 | CREATE SCHEMA """Quotes' \ \' \"" and Space.Dot."; |
| 32 | |
| 33 | CREATE TABLE """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote" |
| 34 | ( |
| 35 | "' id '" SERIAL PRIMARY KEY, |
| 36 | ".namE " TEXT, |
| 37 | ". ' \ \' \"" ""Geom""" GEOMETRY(POINT, 4326) |
| 38 | ); |
| 39 | |
| 40 | INSERT INTO """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote" |
| 41 | values (1, '02daedc70702ec68753fde38351f5d9d', '0101000020E610000050C4D38CE9DA61401EFC0EC7C3DA2740'), |
| 42 | (2, '7418427ba8a960c3661235f47cc13d46', '0101000020E6100000CC2F4170E9DA6140DEDB02B581DA2740'); |
| 43 | |
| 44 | CREATE INDEX ON """Quotes' \ \' \"" and Space.Dot.".". Points"" \ \' \"" 'quote" USING GIST (". ' \ \' \"" ""Geom"""); |
| 45 | }}} |