Re: copying json data and backslashes

2022-11-22 Thread p...@cmicdo.com
On Tuesday, November 22, 2022 at 01:16:02 PM EST, Peter J. Holzer wrote:  > On 2022-11-22 17:39:04 +, Alastair McKinley wrote:  > > > \copy footable from 'input.json' (format csv, escape '^B', delimieter '^C ', quote '^E')  > > >  > > > where the control characters are the actual con

Re: copying json data and backslashes

2022-11-22 Thread p...@cmicdo.com
 >  > On Tuesday, November 22, 2022 at 10:16:11 AM EST, Erik Wienhold wrote:  >  >  > > On 22/11/2022 15:23 CET Alastair McKinley wrote:  > >  > > Hi all,  > >  > > I have come across this apparently common issue COPY-ing json and wondering if  > > there is potentially a better solution.  >

Detecting mis-planning of repeated application of a projection step

2021-10-13 Thread p...@cmicdo.com
The 13.4 release notes document the following:  > Fix mis-planning of repeated application of a projection step (Tom Lane)  >  >  The planner could create an incorrect plan in cases where two  >  ProjectionPaths were stacked on top of each other. The only known  >  way to trigger that

Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

2019-06-20 Thread p...@cmicdo.com
Does the file have any \015's in it? On Wednesday, June 19, 2019, 7:03:25 PM EDT, Andrew Gierth wrote: > "Rob" == Rob Sargent writes: >>> local  all            all                                    trust Rob> That line has four values and the header has 5. That's standard f