Skip site navigation (1) Skip section navigation (2)

psql -c "select * from a-user-name-that-exist fails

From: lalebarde <l(dot)alebarde(at)free(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: psql -c "select * from a-user-name-that-exist fails
Date: 2010-09-23 23:14:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all,

I have just installed PostGreSQL on my Gentoo Linux Desktop for the first
time. Installation is ok. Then, I have started to install an application
that uses PostGreSQL. To test if I am declared as a user in the data base,
it executes the command :

psql -c "select * from laurent

More precisely this bash script :

function exit_if_no_postgres_user
    set +e
    ( psql -q template1 -c "select * from pg_user;" | grep $1 ) \
			    >/dev/null 2>&1 
    if [ $? -eq 1 ]
	echo ""
	echo "*** Error: No postgresql user '$1'"
	echo ""
	exit 1
#    else
#	echo "Good: Postgresql can be accessed by $1"
    set -e
USER=$(whoami) is passed as an argument which is $1

laurent being the user's name. The error is triggered, thought laurent was
declared with the command : createuser -d -A laurent. laurent appears in the
pgadmin3 roles list. As far as I have understood the documentation, roles
and users are the same thing.
Besides, I am surprised by the "template". What is it for ?

Any clue why I get this error ?

View this message in context:
Sent from the PostgreSQL - novice mailing list archive at


pgsql-novice by date

Next:From: Josh KupershmidtDate: 2010-09-24 00:05:32
Subject: Re: psql -c "select * from a-user-name-that-exist fails
Previous:From: Jorge Alberto Fuentes CasillasDate: 2010-09-23 17:22:05
Subject: DB Transfer

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group