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

Re: Simple query question

From: "paul butler" <paul(at)entropia(dot)co(dot)uk>
To: "Chris Boget" <chris(at)wild(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Simple query question
Date: 2002-12-23 13:46:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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
> fine.
> 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
Paul Butler

> thnx,
> Chris
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

In response to


pgsql-novice by date

Next:From: Reshat SabiqDate: 2002-12-23 14:12:19
Subject: Re: Simple query question
Previous:From: Chris BogetDate: 2002-12-23 13:25:03
Subject: Simple query question

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