Compare multiple columns to check if columns are duplicate PostgreSQL
0
I am trying to compare multiple column with each other to find if the columns in a table have similar values or duplicate and each table has more then 200+ columns.
Is there are way to compare using loop in PostgreSQL?
sql postgresql
edited Nov 13 '18 at 17:14
user6910411
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
add a comment |
0
I am trying to compare multiple column with each other to find if the columns in a table have similar values or duplicate and each table has more then 200+ columns.
Is there are way to compare using loop in PostgreSQL?
sql postgresql
edited Nov 13 '18 at 17:14
user6910411
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
You can compare whole rows with a condition like(tab1.*) = (tab2.*). For more, please provide more details.
– Laurenz Albe
Nov 13 '18 at 16:19
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37
add a comment |
0
0
0
I am trying to compare multiple column with each other to find if the columns in a table have similar values or duplicate and each table has more then 200+ columns.
Is there are way to compare using loop in PostgreSQL?
sql postgresql
edited Nov 13 '18 at 17:14
user6910411
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
I am trying to compare multiple column with each other to find if the columns in a table have similar values or duplicate and each table has more then 200+ columns.
Is there are way to compare using loop in PostgreSQL?
sql postgresql
sql postgresql
edited Nov 13 '18 at 17:14
user6910411
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
edited Nov 13 '18 at 17:14
user6910411
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
edited Nov 13 '18 at 17:14
user6910411
33k97095
edited Nov 13 '18 at 17:14
user6910411
33k97095
edited Nov 13 '18 at 17:14
user6910411
33k97095
33k97095
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
asked Nov 13 '18 at 15:39
Dheeraj Jain DDheeraj Jain D
11
11
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
You can compare whole rows with a condition like(tab1.*) = (tab2.*). For more, please provide more details.
– Laurenz Albe
Nov 13 '18 at 16:19
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37
add a comment |
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
You can compare whole rows with a condition like(tab1.*) = (tab2.*). For more, please provide more details.
– Laurenz Albe
Nov 13 '18 at 16:19
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37
1
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
You can compare whole rows with a condition like
(tab1.*) = (tab2.*). For more, please provide more details.– Laurenz Albe
Nov 13 '18 at 16:19
You can compare whole rows with a condition like
(tab1.*) = (tab2.*). For more, please provide more details.– Laurenz Albe
Nov 13 '18 at 16:19
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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
);
);
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53284506%2fcompare-multiple-columns-to-check-if-columns-are-duplicate-postgresql%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53284506%2fcompare-multiple-columns-to-check-if-columns-are-duplicate-postgresql%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
1
Welcome to StackOverflow! Please update your question to show what you have already tried in a Minimal, Complete, and Verifiable example. For further information, please see How to Ask.
– Raoslaw Szamszur
Nov 13 '18 at 15:43
You can compare whole rows with a condition like
(tab1.*) = (tab2.*). For more, please provide more details.– Laurenz Albe
Nov 13 '18 at 16:19
its a single table that has multiple columns. the comparison should be one is to many for example 1:1,1:2,1:3,1:4...etc then again 2:3,2:4,2:5,2:6 and so on...first column compare with all 200 + columns and same type of exercise for 2nd column, 3rd column, 4th column like wise for all the columns ..
– Dheeraj Jain D
Nov 13 '18 at 18:37