AW: Is there a bug in psql? (SELECT ''';)

You have to mask the single quote: https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS Von: Wen Yi <896634...@qq.com> Gesendet: Mittwoch, 31. Mai 2023 09:17 An: pgsql-general Betreff: Is there a bug in psql? (SELECT ''';) Hi team, when I learn the postgres, I

AW: Download file from COPY ... TO with pgadmin

Works as expected on both ways. Thnx. -Ursprüngliche Nachricht- Von: Erik Wienhold Gesendet: Dienstag, 31. Januar 2023 14:58 An: Marco Lechner ; pgsql-general@lists.postgresql.org Betreff: Re: Download file from COPY ... TO with pgadmin > On 31/01/2023 14:02 CET Marco Lechner wr

Download file from COPY ... TO with pgadmin

SELECT the value of the bytea cell, is It possible to download the bytea directly into a file on a client computer when using pgadmin? Is there a solution with the COPY … TO command, any pgadmin specific feature or any other simple solution? Regards Marco i.A. Dr. Marco Lechner Leiter

configure a patroni cluster with a follower who never can become leader

Hi, anyone who can point me to a docu or give me a hint if and how it is possible to configure a patroni cluster in a way that some nodes are follower and can become leader if necessary but there are followers as well that never can become a leader? VG Marco i.A. Dr. Marco Lechner Leiter

follower never to become master

it could be something like the least relevant follower. Anyone who can point me to the documentation, if that configuration use case exists? Thanks in advance i.A. Dr. Marco Lechner Leiter Fachgebiet RN 1 │ Head RN 1 -- Bundesamt für Strahlenschutz │ Federal Office for Radiation Protection

support for DIN SPEC 91379 encoding

. As DIN SPEC 91379 seems to be a national specification (DE) it is based on a European law. I guess other similar international or aat least European compliant encodings should exist or at least other national specs that are compliant with the german DIN SOEC 91379. i.A. Dr. Marco Lechner

AW: how to merge two postgresql server instances into one

/PG12) - template1 (not from PG11/PG12) Used extensions: postgis, hstore. But I see, that another task might be to have user/roles from both PG11 and PG12 copied to PG14. -Ursprüngliche Nachricht- Von: Adrian Klaver Gesendet: Mittwoch, 6. Oktober 2021 17:33 An: Marco Lechner ; pgsql

how to merge two postgresql server instances into one

pg_upgrade to upgrade the larger one and pg_dumpall/pg_restore for the smaller one? Or are there any other nice recommended workflows? i.A. Dr. Marco Lechner Leiter Fachgebiet RN 1 │ Head RN 1 -- Bundesamt für Strahlenschutz │ Federal Office for Radiation Protection Koordination Notfallschutzsysteme

Tool for migrating Gupta SQLBase to PostgreSQL

for good reasons). Anyone here who knows of a tool to convert or migrate Gupta SQLBase (11.6.x) to PostgreSQL? Happy for any hint. Best regards Marco i.A. Dr. Marco Lechner Leiter Fachgebiet RN 1 │ Head RN 1 -- Bundesamt für Strahlenschutz │ Federal Office for Radiation Protection

AW: Linux Update Experience

) [mailto:markus.zwett...@zuerich.ch] Gesendet: Donnerstag, 28. Mai 2020 13:42 An: Marco Lechner ; PostgreSQL General Betreff: AW: Linux Update Experience Hi Marco, How do you handle these conflicts? No longer updating that regularly or not at all anymore? Thanks, Markus Von: Marco Lechner mailto:mlech

AW: Linux Update Experience

.0.0-2.rhel7 Verfügbar: proj70-7.0.0-1.rhel7.x86_64 (oraclelinux7postgresql11) proj70 = 7.0.0-1.rhel7 Fehler: Paket: postgresql12-devel-12.3-1PGDG.rhel7.x86_64 (oraclelinux7postgresql12) Benötigt: llvm-toolset-7-clang >= 4.0.1 Marco -- Dr. Marco Lechner