Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pD7H1-0006cQ-Q6 for pgsql-admin@arkaria.postgresql.org; Wed, 04 Jan 2023 17:09:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pD7Gz-00074Q-Mg for pgsql-admin@arkaria.postgresql.org; Wed, 04 Jan 2023 17:09:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pD7Gz-00074H-8Q for pgsql-admin@lists.postgresql.org; Wed, 04 Jan 2023 17:09:53 +0000 Received: from mail-il1-x12b.google.com ([2607:f8b0:4864:20::12b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pD7Gt-00023I-5T for pgsql-admin@lists.postgresql.org; Wed, 04 Jan 2023 17:09:52 +0000 Received: by mail-il1-x12b.google.com with SMTP id a9so7433395ilk.6 for ; Wed, 04 Jan 2023 09:09:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hayden-ai.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:organization:subject:from:to :content-language:user-agent:mime-version:date:message-id:from:to:cc :subject:date:message-id:reply-to; bh=dL6kzg0yww0g6nR7D0vzO4b6T1/1v0c/4mZo2qCPBLA=; b=mnXBsgsso/7tFirSeWv8MrIRJNx8qpZoz0KOH5IQVklWrUs4U62bkYQuc8mFt5lBP7 0tqRRWJgAZvQewBPZ1seU97AkCAiAYNgfoY26sfa9/tSuBkwJnM2IlBOXo40CNQt0izA TF5mAvP3LJYUiM/Ncyvjp3ArZOrxd8hmlTqO4zPhwnOdHkGVNztACcLrbtYnVnmND1/Z PGMd8cGFnlyn716MMnDwCjivtpR2intGYV7u8AqrshvpveE2dkU32MhhjUAzh6eYwYnH zfSd1taE5XKBfMapHen4hZW4ySkIKqYKtVuJ6BQEwhDO4zOKGzmqQWnYZgh9LFbZizga NLyg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:organization:subject:from:to :content-language:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=dL6kzg0yww0g6nR7D0vzO4b6T1/1v0c/4mZo2qCPBLA=; b=1yp1aG3OF5jk+MRV6924r+kw6yBsuMTPR8lMFQn6Cz9VGRuUQcTUvHQmKAK+8yETwY KMvXEMQL9ujBSuFS/4qRj6lwdn1dA9w06TIi1qcn87xrYSwVXjvgciPPg/YL2HCHRthz I2Ju9W15oYtdeRnvuU7cIvk02ayrJatmzHLjuyY43oJLmU5tBrOtP3dNO/zpcjkZVff1 zME3U03xClVU5Z9KICpI//XuqYxvBaqFhVRdHFti3T/0b+Gp8g2vNX/EGKZnBXwJZMER zue2v0WKRzRRRHjh3nKi7xh1UlyGyq+US6FN6z+BzQysKv6pbS8y94/w1WO+an8n2Lo5 294g== X-Gm-Message-State: AFqh2kqYJE+iAXjuYmA2A2BBGFf3YKSoTRjAcKoxYqJFMOJ3aI8rJnn8 KAslnvMeqpjJZJ2DjprPq4ico9zq8yrtKjhfVeI= X-Google-Smtp-Source: AMrXdXu91PxSUB+DXQlTrLVNjO4aKymc6k3FiWUVIRjz+LEQwFUBgdaRqUcIP7H+gtIHKJBb0Fv75w== X-Received: by 2002:a92:c704:0:b0:30c:20a7:f024 with SMTP id a4-20020a92c704000000b0030c20a7f024mr17220701ilp.1.1672852184843; Wed, 04 Jan 2023 09:09:44 -0800 (PST) Received: from ?IPV6:2601:8c0:900:7df0:b46a:d452:7e2d:a7ba? ([2601:8c0:900:7df0:b46a:d452:7e2d:a7ba]) by smtp.gmail.com with ESMTPSA id m5-20020a026a45000000b003753b6452f9sm10529727jaf.35.2023.01.04.09.09.44 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 04 Jan 2023 09:09:44 -0800 (PST) Message-ID: <2d6cd0bb-67e6-1068-26df-a523e5a2b4e3@hayden.ai> Date: Wed, 4 Jan 2023 10:09:43 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Content-Language: en-US To: pgsql-admin@lists.postgresql.org From: Rich Pixley Subject: csv vs json? Organization: Hayden AI Technologies Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I'm downloading a table in csv using pgAdmin.  Some tables work just fine.  Others have JSON fields in the table and these aren't.  What I get instead is a string with multiple unquoted double quotes that are, correctly I think, complained about by my csv reader. Is there a way to get these quoted properly?  Am I doing something stupid?  Is this a bug?