Ian Bell
2018-04-20 01:55:52 UTC
Hello David,
Very helpful and timely.
Thanks again,
Ian
From: David G. Johnston [mailto:***@gmail.com]
Sent: 19 April, 2018 21:18
To: ***@ianbellsoftware.com
Cc: pgsql-novice <pgsql-***@postgresql.org>
Subject: Re: unable to read composite types from CSV files
On Thursday, April 19, 2018, Ian Bell <***@ianbellsoftware.com <mailto:***@ianbellsoftware.com> > wrote:
If you donât mind, could you point out the section in the PostgreSql manual/documentation where this is discussed/explained. I have repeatedly read section 8.16.6 (i.e. Composite Type Input and Output Syntax) but it does not appear to include this detail.
Your problem is lower-level than the composite type, it's not understanding csv. Read the copy docs, csv format section to learn more.
https://www.postgresql.org/docs/9.6/static/sql-copy.html
The syntax for the composite is embedded in a csv file so first you have to parse the csv then you pass the result to the composite input constructor. If you enter it literally in a script file you can ignore the csv format stuff and go immediately to the syntax of the Typed data you wish to create.
David J.
Very helpful and timely.
Thanks again,
Ian
From: David G. Johnston [mailto:***@gmail.com]
Sent: 19 April, 2018 21:18
To: ***@ianbellsoftware.com
Cc: pgsql-novice <pgsql-***@postgresql.org>
Subject: Re: unable to read composite types from CSV files
On Thursday, April 19, 2018, Ian Bell <***@ianbellsoftware.com <mailto:***@ianbellsoftware.com> > wrote:
If you donât mind, could you point out the section in the PostgreSql manual/documentation where this is discussed/explained. I have repeatedly read section 8.16.6 (i.e. Composite Type Input and Output Syntax) but it does not appear to include this detail.
Your problem is lower-level than the composite type, it's not understanding csv. Read the copy docs, csv format section to learn more.
https://www.postgresql.org/docs/9.6/static/sql-copy.html
The syntax for the composite is embedded in a csv file so first you have to parse the csv then you pass the result to the composite input constructor. If you enter it literally in a script file you can ignore the csv format stuff and go immediately to the syntax of the Typed data you wish to create.
David J.