From cc6c10a7a0245b87fa49e1369bc94c88fcbdb987 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 21 Nov 2006 15:38:09 +0000 Subject: Add capitalization mention. --- doc/src/FAQ/FAQ.html | 21 +++++++++++---------- 1 file changed, 11 insertions(+), 10 deletions(-) (limited to 'doc/src') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 8da16e9ee9a..6231f266efb 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sat Oct 14 19:08:19 EDT 2006

+

Last updated: Tue Nov 21 10:37:54 EST 2006

Current maintainer: Bruce Momjian (bruce@momjian.us) @@ -117,7 +117,7 @@ functions?
4.20) What replication solutions are available?
4.21) Why are my table and column names not - recognized in my query?
+ recognized in my query? Why is capitalization not preserved?

@@ -1085,16 +1085,17 @@ length available supporting a variety of replication models.

4.21) Why are my table and column names not - recognized in my query?

+ recognized in my query? Why is capitalization not preserved? -

The most common cause is the use of double-quotes around table or - column names during table creation. When double-quotes are used, - table and column names (called identifiers) are stored +

The most common cause of recognized names is the use of + double-quotes around table or column names during table creation. + When double-quotes are used, table and column names (called + identifiers) are stored case-sensitive, meaning you must use double-quotes when - referencing the names in a query. Some interfaces, like pgAdmin, - automatically double-quote identifiers during table creation. So, - for identifiers to be recognized, you must either: + referencing the names in a query. Some interfaces, like pgAdmin, + automatically double-quote identifiers during table creation. + So, for identifiers to be recognized, you must either: