From: "Chris Boget" <chris(at)wild(dot)net>
To: "PGSql Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: [NOVICE] Simple query question
Date sent: Mon, 23 Dec 2002 07:25:03 -0600
> I'm in the process of converting my site from MySQL to PGSQL and
> I've come across something odd that I can't find an explenation for in
> the documentation.
The section called basic sql commands, double quotes seem to be
reserved for objects(relations/attributes) though are not required so
if you double quote (or not quote) a value in a where clause pgsql
will look for the corresponding object and most likely fail. Always
enclose values in single quotes.
> All my MySQL queries use double quotes around the field value I am
> looking for. IE
> SELECT * FROM sessions WHERE session_name = "session_name"
> However, when I run that in PGSQL, I get an error message:
> ERROR: Attribute "session_name" not found
> But if I replace the double quotes with single quotes, the query runs
> Where in the documentation can I find why that is?
> Also, in MySQL you could use \G after the query (instead of using a
> semi colon) so that the record set would be displayed with the columns
> vertical instead of horizontal. This is especially useful when you are
> using the command line. Does PGSQL have something like that? This
> is something else I couldn't find in the documentation.
In psql typing \x will toggle the display
hope this helps
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
In response to
pgsql-novice by date
|Next:||From: Reshat Sabiq||Date: 2002-12-23 14:12:19|
|Subject: Re: Simple query question|
|Previous:||From: Chris Boget||Date: 2002-12-23 13:25:03|
|Subject: Simple query question|