Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitcc6c10a

Browse files
committed
Add capitalization mention.
1 parent150328c commitcc6c10a

File tree

2 files changed

+22
-19
lines changed

2 files changed

+22
-19
lines changed

‎doc/FAQ

Lines changed: 11 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Sat Oct 14 19:08:19 EDT 2006
4+
Last updated:Tue Nov 21 10:37:54 EST 2006
55

66
Current maintainer: Bruce Momjian (bruce@momjian.us)
77

@@ -79,6 +79,7 @@
7979
when accessing temporary tables in PL/PgSQL functions?
8080
4.20) What replication solutions are available?
8181
4.21) Why are my table and column names not recognized in my query?
82+
Why is capitalization not preserved?
8283
_________________________________________________________________
8384

8485
General Questions
@@ -830,15 +831,16 @@
830831
There are also commercial and hardware-based replication solutions
831832
available supporting a variety of replication models.
832833

833-
4.21) Why are my table and column names not recognized in my query?
834+
4.21) Why are my table and column names not recognized in my query? Why is
835+
capitalization not preserved?
834836

835-
The most common cause is the use of double-quotes around table or
836-
column names during table creation. When double-quotes are used, table
837-
and column names (called identifiers) are stored case-sensitive,
838-
meaning you must use double-quotes when referencing the names in a
839-
query. Some interfaces, like pgAdmin, automatically double-quote
840-
identifiers during table creation. So, for identifiers to be
841-
recognized, you must either:
837+
The most common causeof recognized namesis the use of double-quotes
838+
around table orcolumn names during table creation. When double-quotes
839+
are used, tableand column names (called identifiers) are stored
840+
case-sensitive,meaning you must use double-quotes when referencing
841+
the names in aquery. Some interfaces, like pgAdmin, automatically
842+
double-quoteidentifiers during table creation. So, for identifiers to
843+
berecognized, you must either:
842844
* Avoid double-quoting identifiers when creating tables
843845
* Use only lowercase characters in identifiers
844846
* Double-quote identifiers when referencing them in queries

‎doc/src/FAQ/FAQ.html

Lines changed: 11 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated:Sat Oct 14 19:08:19 EDT 2006</P>
13+
<P>Last updated:Tue Nov 21 10:37:54 EST 2006</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -117,7 +117,7 @@ <H2 align="center">Operational Questions</H2>
117117
functions?<BR>
118118
<Ahref="#item4.20">4.20</A>) What replication solutions are available?<BR>
119119
<Ahref="#item4.21">4.21</A>) Why are my table and column names not
120-
recognized in my query?<BR>
120+
recognized in my query? Why is capitalization not preserved?<BR>
121121

122122

123123
<HR>
@@ -1085,16 +1085,17 @@ <H3 id="item4.20">4.20) What replication solutions are available?
10851085
available supporting a variety of replication models.</P>
10861086

10871087
<H3id="item4.21">4.21) Why are my table and column names not
1088-
recognized in my query?</H3>
1088+
recognized in my query? Why is capitalization not preserved?</H3>
10891089

1090-
<P>The most common cause is the use of double-quotes around table or
1091-
column names during table creation. When double-quotes are used,
1092-
table and column names (called identifiers) are stored<a
1093-
href="http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS">
1090+
<P>The most common cause of recognized names is the use of
1091+
double-quotes around table or column names during table creation.
1092+
When double-quotes are used, table and column names (called
1093+
identifiers) are stored<a
1094+
href="http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS">
10941095
case-sensitive</a>, meaning you must use double-quotes when
1095-
referencing the names in a query. Some interfaces, like pgAdmin,
1096-
automatically double-quote identifiers during table creation. So,
1097-
for identifiers to be recognized, you must either:
1096+
referencing the names in a query.Some interfaces, like pgAdmin,
1097+
automatically double-quote identifiers during table creation.
1098+
So,for identifiers to be recognized, you must either:
10981099
<UL>
10991100
<LI>Avoid double-quoting identifiers when creating tables</LI>
11001101
<LI>Use only lowercase characters in identifiers</LI>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp