summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorDaniele Varrazzo <daniele.varrazzo@gmail.com>2021-06-17 16:52:44 +0100
committerDaniele Varrazzo <daniele.varrazzo@gmail.com>2021-06-17 16:52:44 +0100
commit47b93efcf8fb4aa2de12fb1e690b87a1e73515da (patch)
tree7667583a7a5954976db2ff435fe38bf1dbf2427b /doc/src
parent7749898a949ca518a6aaa3eba5a48fa0e8bfc3ca (diff)
downloadpsycopg2-47b93efcf8fb4aa2de12fb1e690b87a1e73515da.tar.gz
Note in the docs that now the table and fields names are escaped.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/cursor.rst22
1 files changed, 9 insertions, 13 deletions
diff --git a/doc/src/cursor.rst b/doc/src/cursor.rst
index b3e3b42..a0d66bc 100644
--- a/doc/src/cursor.rst
+++ b/doc/src/cursor.rst
@@ -562,13 +562,6 @@ The ``cursor`` class
>>> cur.fetchall()
[(6, 42, 'foo'), (7, 74, 'bar')]
- .. note:: the name of the table is not quoted: if the table name
- contains uppercase letters or special characters it must be quoted
- with double quotes::
-
- cur.copy_from(f, '"TABLE"')
-
-
.. versionchanged:: 2.0.6
added the *columns* parameter.
@@ -577,6 +570,11 @@ The ``cursor`` class
are encoded in the connection `~connection.encoding` when sent to
the backend.
+ .. versionchanged:: 2.9
+ the table and fields names are now quoted. If you need to specify
+ a schema-qualified table please use `copy_expert()`.
+
+
.. method:: copy_to(file, table, sep='\\t', null='\\\\N', columns=None)
Write the content of the table named *table* *to* the file-like
@@ -598,12 +596,6 @@ The ``cursor`` class
2|\N|dada
...
- .. note:: the name of the table is not quoted: if the table name
- contains uppercase letters or special characters it must be quoted
- with double quotes::
-
- cur.copy_to(f, '"TABLE"')
-
.. versionchanged:: 2.0.6
added the *columns* parameter.
@@ -612,6 +604,10 @@ The ``cursor`` class
are decoded in the connection `~connection.encoding` when read
from the backend.
+ .. versionchanged:: 2.9
+ the table and fields names are now quoted. If you need to specify
+ a schema-qualified table please use `copy_expert()`.
+
.. method:: copy_expert(sql, file, size=8192)