Thread: RESOLVED: unable to read composite types from CSV files
Hello David,
Very helpful and timely.
Thanks again,
Ian
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: 19 April, 2018 21:18
To: ib@ianbellsoftware.com
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: unable to read composite types from CSV files
On Thursday, April 19, 2018, Ian Bell <ib@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.
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.