How to fix this problem in postgres psql command?

Question

In the psql shell . It working fine to run sql . But when i use the psql -c . It's has problem.

postgres@03e0948a4fed:/home/data$ psql --c "select version();"
                                                             version
----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 11.4 (Debian 11.4-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
(1 row)
postgres@03e0948a4fed:/home/data$ psql
psql (11.4 (Debian 11.4-1.pgdg90+1))
Type "help" for help.

postgres=# truncate table "TEST"."E0005";
TRUNCATE TABLE

postgres@03e0948a4fed:/home/data$ psql --c "truncate" "table" "TEST"."E0005";
psql: FATAL:  role "TEST.E0005" does not exist

postgres@03e0948a4fed:/home/data$ psql --c "truncate table TEST.E0005;" `ERROR: schema "TEST" does not exist.`

I want to know how to use psql --c to run the sql truncate table TEST.E0005; — guo lei li
– guo lei li, Commented Jul 18, 2019 at 2:09
What's meaning "psql: FATAL: role "TEST.E0005" does not exist ?" — guo lei li
– guo lei li, Commented Jul 18, 2019 at 2:29
The command you put at the end is close, with the full command in quotes, but it should be -c instead of --c — Jeremy
– Jeremy, Commented Jul 18, 2019 at 2:34
@Jeremy Thank you !! I tied to use '-c' postgres@03e0948a4fed:/$ psql -c "truncate table TEST.E0005;" ERROR: schema "TEST" does not exist . What's the problem ? — guo lei li
– guo lei li, Commented Jul 18, 2019 at 3:09

Laurenz Albe · Accepted Answer · 2019-07-18 04:50:02Z

2

There are two problems:

The argument to -c bust be a single string
You cannot nest the same quotes without escaping them.

So you have two solutions:

psql -c 'TRUNCATE TABLE "TEST"."E0005"'

or

psql -c "TRUNCATE TABLE \"TEST\".\"E0005\""

answered Jul 18, 2019 at 4:50

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fphilipe · Accepted Answer · 2019-07-18 05:49:11Z

1

To add to Laurenz Albe's answer, you could also pass the command through standard input without worrying about quotes.

psql <<eof
  TRUNCATE TABLE "TEST"."E0005"
eof

answered Jul 18, 2019 at 5:49

fphilipe

10.1k1 gold badge42 silver badges55 bronze badges

Collectives™ on Stack Overflow

How to fix this problem in postgres psql command?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related