On 7/14/25 12:38, Rich Shepard wrote:
Reply to list also.
Ccing list.
> On Mon, 14 Jul 2025, Adrian Klaver wrote:
>
>> The above looks like the format 'aligned' output from a query.
>
> Adrian,
>
> I mistyped the script's extension as .txt rather than .sql.
That does not matter, that is more for user convenience in figuring out
what the files are for.
\o test.txt
select * from cell_per;
Then doing:
psql -d production -U postgres -h localhost -p 5432 -f test.sql
Null display is "NULL".
psql:test.sql:82: ERROR: syntax error at or near "line_id"
LINE 1: line_id | category | cell_per | ts_insert |
psql -d production -U postgres -h localhost -p 5432 -f test.txt
Null display is "NULL".
psql:test.txt:82: ERROR: syntax error at or near "line_id"
LINE 1: line_id | category | cell_per | ts_insert | ...
The error is the same as psql just processes the file without regard to
the extension.
>
> Regards,
>
> Rich
--
Adrian Klaver
adrian.klaver@aklaver.com
