Re: csv vs json?

Поиск
Список
Период
Сортировка
От Samed YILDIRIM
Тема Re: csv vs json?
Дата
Msg-id CAAo1mbnwuqx0qKA-OW_eRAiee0Y+2gF5NwVnkefHJesgaT5H2Q@mail.gmail.com
обсуждение исходный текст
Ответ на csv vs json?  (Rich Pixley <rich.pixley@hayden.ai>)
Ответы Re: csv vs json?  (Rich Pixley <rich.pixley@hayden.ai>)
Список pgsql-admin
Hi Rich,

It is hard to say what the problem is you encountered and offer any solution. Can you share the error message you got and example lines from your csv file?

I only can recommend you to check the document on the link below. CSV format of file might not match with default settings of PostgreSQL. You can adjust via parameters, such as delimiter, quote, and escape.


Best regards.
Samed YILDIRIM


On Wed, 4 Jan 2023 at 19:10, Rich Pixley <rich.pixley@hayden.ai> wrote:
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?




В списке pgsql-admin по дате отправления:

Предыдущее
От: Alexander Pogodin
Дата:
Сообщение: Cascaded Replication question
Следующее
От: Samed YILDIRIM
Дата:
Сообщение: Re: MSSQL to PostgreSQL Migration