diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-11-21 15:38:09 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-11-21 15:38:09 +0000 |
| commit | cc6c10a7a0245b87fa49e1369bc94c88fcbdb987 (patch) | |
| tree | c5b268869e67a5a248b2bd43b929e6dc64a9bc79 /doc/src/FAQ/FAQ.html | |
| parent | 150328cd61f5925df80fbf52f6f0208fa2c93a7e (diff) | |
Add capitalization mention.
Diffstat (limited to 'doc/src/FAQ/FAQ.html')
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 21 |
1 files changed, 11 insertions, 10 deletions
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"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Sat Oct 14 19:08:19 EDT 2006</P> + <P>Last updated: Tue Nov 21 10:37:54 EST 2006</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:bruce@momjian.us">bruce@momjian.us</A>) @@ -117,7 +117,7 @@ functions?<BR> <A href="#item4.20">4.20</A>) What replication solutions are available?<BR> <A href="#item4.21">4.21</A>) Why are my table and column names not - recognized in my query?<BR> + recognized in my query? Why is capitalization not preserved?<BR> <HR> @@ -1085,16 +1085,17 @@ length</TD></TR> available supporting a variety of replication models.</P> <H3 id="item4.21">4.21) Why are my table and column names not - recognized in my query?</H3> + recognized in my query? Why is capitalization not preserved?</H3> - <P>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 <a - href="http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS"> + <P>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 <a + href="http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS"> case-sensitive</a>, 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: <UL> <LI>Avoid double-quoting identifiers when creating tables</LI> <LI>Use only lowercase characters in identifiers</LI> |