On 9/16/24 09:12, Andy Hartman wrote:
2024-09-16 12:06:00.968 EDT [4968] ERROR: relation
"image_classification_master" does not exist
2024-09-16 12:06:00.968 EDT [4968] STATEMENT: COPY
Image_Classification_Master FROM STDIN DELIMITER ',' CSV HEADER;
I'm assuming this is from the Postgres log.
Best guess is the table name in the database is mixed case and needs to
be double quoted in the command to preserve the casing.
See:
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
for why.
On Mon, Sep 16, 2024 at 11:52 AM Francisco Olarte
<folarte@xxxxxxxxxxxxxx <mailto:folarte@xxxxxxxxxxxxxx>> wrote:
On Mon, 16 Sept 2024 at 17:36, Andy Hartman <hartman60home@xxxxxxxxx
<mailto:hartman60home@xxxxxxxxx>> wrote:
I'm trying to run this piece of code from Powershell and it just
sits there and never comes back. There are only 131 records in
the csv.
$connectionString =
"Host=$pgServer;Database=$pgDatabase;Username=$pgUser;Password=$pgPassword"
$copyCommand = "\COPY $pgTable FROM '$csvPath' DELIMITER ',' CSV
HEADER;"
psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand
how can I debug this?
I would start by adding -a and -e after "psql".
IIRC Powershell is windows, and in windows shell do not pass command
words preparsed as in *ix to the executable, but a single command
line with the executable must parse. Given the amount of quoting, -a
and -e will let you see the commands are properly sent, and if it is
trying to read something what it is.
I will also try to substitute the -c with a pipe. If it heals, it is
probably a quoting issue.
Also, I just caught Ron's message, and psql might be waiting for a
password.
Francisco Olarte.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
