On Thu, 26 Jan 2006, Stephan Szabo wrote:
Did you put a semicolon at the end of the command? I get a ERROR: syntax error at or near "username" at character 26 LINE 1: create database contacts username=sszabo
Stephan, No, I did not put a semicolon there. I also received no error message, just the prompt. See the sample session I just posted in response to Michael's message.
psql defaults to connecting to a database of the same name as the user when no database name is given.
I now understand this. Thanks, Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
