What template was used to create my PostgreSQL database
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a PostgreSQL database that I think was create using a custom template database.
Is there a way to see what template was used to create the database? There doesn't seem to be any documentation that describes this.
postgresql
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
add a comment |
I have a PostgreSQL database that I think was create using a custom template database.
Is there a way to see what template was used to create the database? There doesn't seem to be any documentation that describes this.
postgresql
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30
add a comment |
I have a PostgreSQL database that I think was create using a custom template database.
Is there a way to see what template was used to create the database? There doesn't seem to be any documentation that describes this.
postgresql
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
I have a PostgreSQL database that I think was create using a custom template database.
Is there a way to see what template was used to create the database? There doesn't seem to be any documentation that describes this.
postgresql
postgresql
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
asked Nov 17 '18 at 7:19
onknowsonknows
1,08721945
1,08721945
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30
add a comment |
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30
add a comment |
1 Answer
1
active
oldest
votes
As far as I know, no, there is no system catalogue that tracks this. I'm not sure it would be terribly useful to know that database "X" was created from "template2" unless you could prove exactly what the contents of "template2" were at the point of copying. If you're tracking things to that level of detail then you will already have the creation logged.
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
add a comment |
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
});
}
});
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%2f53349122%2fwhat-template-was-used-to-create-my-postgresql-database%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
As far as I know, no, there is no system catalogue that tracks this. I'm not sure it would be terribly useful to know that database "X" was created from "template2" unless you could prove exactly what the contents of "template2" were at the point of copying. If you're tracking things to that level of detail then you will already have the creation logged.
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
add a comment |
As far as I know, no, there is no system catalogue that tracks this. I'm not sure it would be terribly useful to know that database "X" was created from "template2" unless you could prove exactly what the contents of "template2" were at the point of copying. If you're tracking things to that level of detail then you will already have the creation logged.
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
add a comment |
As far as I know, no, there is no system catalogue that tracks this. I'm not sure it would be terribly useful to know that database "X" was created from "template2" unless you could prove exactly what the contents of "template2" were at the point of copying. If you're tracking things to that level of detail then you will already have the creation logged.
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
As far as I know, no, there is no system catalogue that tracks this. I'm not sure it would be terribly useful to know that database "X" was created from "template2" unless you could prove exactly what the contents of "template2" were at the point of copying. If you're tracking things to that level of detail then you will already have the creation logged.
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
answered Nov 17 '18 at 9:25
Richard HuxtonRichard Huxton
15.6k12436
15.6k12436
add a comment |
add a comment |
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.
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%2f53349122%2fwhat-template-was-used-to-create-my-postgresql-database%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
It is hard to prove a negative but it is not in the pg_database catalog table nor does pgAdmin specify it when it shows the create statement for a database. If you really need to know you will have to test for the existence or lack thereof for certain objects it would have copied from the template.
– Eelke
Nov 17 '18 at 10:30