search

freelawproject / courtlistener

A fully-searchable and accessible archive of court data including growing repositories of opinions, oral arguments, judges, judicial financial records, and federal filings.
https://www.courtlistener.com
Other
531 stars 146 forks source link

Load data script syntax error + server side COPY command used #4326

Closed hopperj closed 3 weeks ago

hopperj commented 3 weeks ago

The script generated by the data export to load the data uses a quote character defined as \'\', which is missing an escape on the '' character itself. This breaks the command parsing and causes a syntax error.

Additionally, the COPY command is a server side only call, and should be replaced with \COPY so users can run the script as intended.

hopperj commented 3 weeks ago

PR to address these issues: https://github.com/freelawproject/courtlistener/pull/4327