| From: | Samed YILDIRIM <samed(at)reddoc(dot)net> |
|---|---|
| To: | Rich Pixley <rich(dot)pixley(at)hayden(dot)ai> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: csv vs json? |
| Date: | 2023-01-09 22:55:47 |
| Message-ID: | CAAo1mbnwuqx0qKA-OW_eRAiee0Y+2gF5NwVnkefHJesgaT5H2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
https://www.postgresql.org/docs/current/sql-copy.html
Best regards.
Samed YILDIRIM
On Wed, 4 Jan 2023 at 19:10, Rich Pixley <rich(dot)pixley(at)hayden(dot)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?
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samed YILDIRIM | 2023-01-09 22:59:22 | Re: MSSQL to PostgreSQL Migration |
| Previous Message | Alexander Pogodin | 2023-01-09 15:24:27 | Cascaded Replication question |