How can I drop a PostgreSQL table with double quotes in its name?
I've inadvertedly created the following table, which I can't remove:
db=> dt
List of relations
Schema | Name | Type | Owner
--------+---------------------+-------+---------------
public | "dm"."feedbacks" | table | write
What is the right DROP TABLE string to delete it?
postgresql
asked Jan 16 at 16:50
user582175user582175
31
add a comment |
I've inadvertedly created the following table, which I can't remove:
db=> dt
List of relations
Schema | Name | Type | Owner
--------+---------------------+-------+---------------
public | "dm"."feedbacks" | table | write
What is the right DROP TABLE string to delete it?
postgresql
asked Jan 16 at 16:50
user582175user582175
31
add a comment |
I've inadvertedly created the following table, which I can't remove:
db=> dt
List of relations
Schema | Name | Type | Owner
--------+---------------------+-------+---------------
public | "dm"."feedbacks" | table | write
What is the right DROP TABLE string to delete it?
postgresql
asked Jan 16 at 16:50
user582175user582175
31
I've inadvertedly created the following table, which I can't remove:
db=> dt
List of relations
Schema | Name | Type | Owner
--------+---------------------+-------+---------------
public | "dm"."feedbacks" | table | write
What is the right DROP TABLE string to delete it?
postgresql
postgresql
asked Jan 16 at 16:50
user582175user582175
31
asked Jan 16 at 16:50
user582175user582175
31
asked Jan 16 at 16:50
user582175user582175
31
asked Jan 16 at 16:50
user582175user582175
31
asked Jan 16 at 16:50
user582175user582175
31
31
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Postgress allows you to use 2 consecutive double quotes characters to escape a double quote inside a string - so i think your DROP command will look like this:
DROP TABLE """dm"".""feedbacks"""
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1395031%2fhow-can-i-drop-a-postgresql-table-with-double-quotes-in-its-name%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Postgress allows you to use 2 consecutive double quotes characters to escape a double quote inside a string - so i think your DROP command will look like this:
DROP TABLE """dm"".""feedbacks"""
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
add a comment |
Postgress allows you to use 2 consecutive double quotes characters to escape a double quote inside a string - so i think your DROP command will look like this:
DROP TABLE """dm"".""feedbacks"""
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
add a comment |
Postgress allows you to use 2 consecutive double quotes characters to escape a double quote inside a string - so i think your DROP command will look like this:
DROP TABLE """dm"".""feedbacks"""
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
Postgress allows you to use 2 consecutive double quotes characters to escape a double quote inside a string - so i think your DROP command will look like this:
DROP TABLE """dm"".""feedbacks"""
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
answered Jan 16 at 19:33
MisterSmithMisterSmith
2645
2645
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1395031%2fhow-can-i-drop-a-postgresql-table-with-double-quotes-in-its-name%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
