im trying now to:
postgres@ADserver:~$ psql -c 'COPY TABLE_NAME (id, id2) FROM '/var/lib/postgresql/pid_cpu' DELIMITER ' ';'
psql: error: FATAL: database ";" does not exist
Loading
im trying now to:
postgres@ADserver:~$ psql -c 'COPY TABLE_NAME (id, id2) FROM '/var/lib/postgresql/pid_cpu' DELIMITER ' ';'
psql: error: FATAL: database ";" does not exist
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Jul 21, 2021, 10:36 AM
Mallesh MalluPosted Jul 22, 2021, 3:09 AM
Rajeesh MenothPosted Jul 20, 2021, 6:20 AM
Hi,
I don't think single quotes not required for semi-colon ';'
Reference :
https://www.postgresql.org/docs/9.0/sql-copy.html