8000 pg_dump docs: use escaped double-quotes, for Windows · postgres/postgres@605b4c5 · GitHub
[go: up one dir, main page]
Skip to content
{"payload":{"commit":{"oid":"605b4c5a6b4708d9a72c205cb5b14b5f57bd53a8","url":"/postgres/postgres/commit/605b4c5a6b4708d9a72c205cb5b14b5f57bd53a8","authoredDate":"2013-07-01T14:52:56.000-04:00","committedDate":"2013-07-01T14:52:59.000-04:00","shortMessage":null,"shortMessageMarkdown":"\u003cdiv\u003epg_dump docs: use escaped double-quotes, for Windows\u003c/div\u003e","shortMessageMarkdownLink":null,"bodyMessageHtml":"On Unix, you can embed double-quotes in single-quotes, and via versa.\nHowever, on Windows, you can only escape double-quotes in double-quotes,\nso use that in the pg_dump -t/table example.\nBackpatch to 9.3.\nReport from Mike Toews","authors":[{"login":"bmomjian","displayName":"Bruce Momjian","avatarUrl":"https://avatars.githubusercontent.com/u/412153?v=4","path":"/bmomjian","isGitHub":false}],"committerAttribution":false,"committer":{"login":"bmomjian","displayName":"Bruce Momjian","avatarUrl":"https://avatars.githubusercontent.com/u/412153?v=4","path":"/bmomjian","isGitHub":false},"parents":["0d22987ae9fe5dc9861e314f1609c8b69d61bbfc"],"globalRelayId":"MDY6Q29tbWl0OTI3NDQyOjYwNWI0YzVhNmI0NzA4ZDlhNzJjMjA1Y2I1YjE0YjVmNTdiZDUzYTg=","sha1":"0d22987ae9fe5dc9861e314f1609c8b69d61bbfc","sha2":"605b4c5a6b4708d9a72c205cb5b14b5f57bd53a8"},"currentUser":null,"repo":{"id":927442,"defaultBranch":"master","name":"postgres","ownerLogin":"postgres","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-09-21T11:35:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/177543?v=4","public":true,"private":false,"isOrgOwned":true},"diffEntryData":[{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":1223,"text":"@@ -1224,7 +1224,7 @@ CREATE DATABASE foo WITH TEMPLATE template0;","html":"@@ -1224,7 +1224,7 @@ CREATE DATABASE foo WITH TEMPLATE template0;","displayNoNewLineWarning":false,"position":0,"left":1223,"right":1223},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1224,"text":" like","html":" like","displayNoNewLineWarning":false,"position":1,"left":1224,"right":1224},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1225,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":2,"left":1225,"right":1225},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1226,"text":" \u003cscreen\u003e","html":" \u0026lt;screen\u0026gt;","displayNoNewLineWarning":false,"position":3,"left":1226,"right":1226},{"stylingDirective":null,"type":"DELETION","blobLineNumber":1227,"text":"-\u003cprompt\u003e$\u003c/prompt\u003e \u003cuserinput\u003epg_dump -t '\"MixedCaseName\"' mydb \u0026gt; mytab.sql\u003c/userinput\u003e","html":"-\u0026lt;prompt\u0026gt;$\u0026lt;/prompt\u0026gt; \u0026lt;userinput\u0026gt;pg_dump -t \u003cspan class=\"x x-first x-last\"\u003e\u0026#39;\u0026quot;\u003c/span\u003eMixedCaseName\u003cspan class=\"x x-first x-last\"\u003e\u0026quot;\u0026#39;\u003c/span\u003e mydb \u0026amp;gt; mytab.sql\u0026lt;/userinput\u0026gt;","displayNoNewLineWarning":false,"position":4,"left":1227,"right":1226},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":1227,"text":"+\u003cprompt\u003e$\u003c/prompt\u003e \u003cuserinput\u003epg_dump -t \"\\\"MixedCaseName\\\"\" mydb \u0026gt; mytab.sql\u003c/userinput\u003e","html":"+\u0026lt;prompt\u0026gt;$\u0026lt;/prompt\u0026gt; \u0026lt;userinput\u0026gt;pg_dump -t \u003cspan class=\"x x-first x-last\"\u003e\u0026quot;\\\u0026quot;\u003c/span\u003eMixedCaseName\u003cspan class=\"x x-first x-last\"\u003e\\\u0026quot;\u0026quot;\u003c/span\u003e mydb \u0026amp;gt; mytab.sql\u0026lt;/userinput\u0026gt;","displayNoNewLineWarning":false,"position":5,"left":1227,"right":1227},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1228,"text":" \u003c/screen\u003e\u003c/para\u003e","html":" \u0026lt;/screen\u0026gt;\u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":6,"left":1228,"right":1228},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1229,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":7,"left":1229,"right":1229},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":1230,"text":" \u003c/refsect1\u003e","html":" \u0026lt;/refsect1\u0026gt;","displayNoNewLineWarning":false,"position":8,"left":1230,"right":1230}],"diffNumber":0,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":1242,"linesChanged":2,"newTreeEntry":{"lineCount":1242,"path":"doc/src/sgml/ref/pg_dump.sgml","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"doc/src/sgml/ref/pg_dump.sgml","mode":100644},"linesAdded":1,"linesDeleted":1,"path":"doc/src/sgml/ref/pg_dump.sgml","pathDigest":"c1aac8deb74b3d1936ee8640e6c534f6cb122d6dfcf35fcc180b8d35c6942035","status":"MODIFIED","truncatedReason":null,"oldOid":"0d22987ae9fe5dc9861e314f1609c8b69d61bbfc","newOid":"605b4c5a6b4708d9a72c205cb5b14b5f57bd53a8","copilotChatReference":null,"deletedSha":"0d22987ae9fe5dc9861e314f1609c8b69d61bbfc","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null}],"splitViewPreference":"unified","ignoreWhitespace":false,"repoOwnerGlobalRelayId":"MDEyOk9yZ2FuaXphdGlvbjE3NzU0Mw==","commentsPreference":"visible","diffLineSpacingPreference":"relaxed","useMonospaceFont":false,"pasteUrlLinkAsPlainText":false,"userNotices":[],"path":"/postgres/postgres/commit/605b4c5a6b4708d9a72c205cb5b14b5f57bd53a8","fileTreeExpanded":true,"headerInfo":{"additions":1,"deletions":1,"filesChanged":1,"filesChangedString":"1"},"moreDiffsToLoad":false,"asyncDiffLoadInfo":{"startIndex":1,"truncated":false,"byteCount":307,"lineShownCount":9},"commentInfo":{"canComment":false,"locked":false,"canLock":false,"repoArchived":false},"csrf_tokens":{"/users/diffview?diff=split":{"post":"zuVpd8dSZEZixDZv5JjCOhU3pQlnyQ1aGDr3JTOI76d1R44Exb5C8hVcJ_Euz69cgE7y9pDxM8P2LdbOVkW8Ng"},"/users/diffview?diff=unified":{"post":"vPgRNOgEVGggAl1yL3GDpJrklLD_DCuISpKNVya-lEMHWvZH6uhy3FeaTOzlJu7CD53DTwg0FRGkhay8Q3PH0g"},"/notifications/thread":{"post":"Crw-FAZkCD7CJ_fjWHoKy5SXxPQyPO5a8nDZAheUopyTO4nIqQ6npiOnnwSxFw0OO8DxwhnHQqqslg9f5GPlZA"}}},"title":"pg_dump docs: use escaped double-quotes, for Windows · postgres/postgres@605b4c5","appPayload":{"helpUrl":"https://docs.github.com","findInDiffWorkerPath":"/assets-cdn/worker/find-in-diff-worker-2bfe39677d14.js","enabled_features":{"diff_ux_refresh_beta":false,"diff_inline_comments":true,"diff_ux_refresh_ssr_five":false,"diff_ux_refresh_ssr_ten":false,"react_diff_line_type_character_correction":true}}}

Commit 605b4c5

Browse files
bmomjianbmomjian
committed
pg_dump docs: use escaped double-quotes, for Windows
On Unix, you can embed double-quotes in single-quotes, and via versa. However, on Windows, you can only escape double-quotes in double-quotes, so use that in the pg_dump -t/table example. Backpatch to 9.3. Report from Mike Toews
1 parent 0d22987 commit 605b4c5

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

‎doc/src/sgml/ref/pg_dump.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1224,7 +1224,7 @@ CREATE DATABASE foo WITH TEMPLATE template0;
12241224
like
12251225

12261226
<screen>
1227-
<prompt>$</prompt> <userinput>pg_dump -t '"MixedCaseName"' mydb &gt; mytab.sql</userinput>
1227+
<prompt>$</prompt> <userinput>pg_dump -t "\"MixedCaseName\"" mydb &gt; mytab.sql</userinput>
12281228
</screen></para>
12291229

12301230
</refsect1>

0 commit comments

Comments
 (0)
0