diff options
author | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-06-17 16:52:44 +0100 |
---|---|---|
committer | Daniele Varrazzo <daniele.varrazzo@gmail.com> | 2021-06-17 16:52:44 +0100 |
commit | 47b93efcf8fb4aa2de12fb1e690b87a1e73515da (patch) | |
tree | 7667583a7a5954976db2ff435fe38bf1dbf2427b | |
parent | 7749898a949ca518a6aaa3eba5a48fa0e8bfc3ca (diff) | |
download | psycopg2-47b93efcf8fb4aa2de12fb1e690b87a1e73515da.tar.gz |
Note in the docs that now the table and fields names are escaped.
-rw-r--r-- | doc/src/cursor.rst | 22 |
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) |