PostgreSQL Command fom bash script

Question

I work with PostgreSQL 9.2 and bash script. I have a problem.

My DB is TestDB , Table name is config

and my bash code is

sudo -u postgres psql -c "select count(*) from public.config where var_name='url'"

result is

ERROR: relation "public.config" does not exist

Can anybody help me?

sudo -u postgres psql TestDB -c "select count(*) from config where var_name='url'" — cptPH, Jul 12 '13 at 11:39
@Patrick You should make that an answer, so that it can be accepted. — Ansgar Wiechers, Jul 12 '13 at 11:44

cptPH · Accepted Answer · 2013-07-12 11:45:40Z

up vote 3 down vote accepted

sudo -u postgres psql TestDB -c "select count(*) from config where var_name='url'

The Database was missing, so you executed the command into postgres db where you probably don't have that table ;-)

answered Jul 12 '13 at 11:45

cptPH
733518

add a comment |

1 Answer 1