Mixing
How to know on what OS/Platform the Postgresql Server runns?
i am trying to write a SQL function that determines if the Postgres Server is running on windows, is that possible, or is there a way to get the platform of a running Server?
postgresql postgresql-9.3 postgresql-9.4 postgresql-9.2 postgresql-9.5
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
add a comment |
i am trying to write a SQL function that determines if the Postgres Server is running on windows, is that possible, or is there a way to get the platform of a running Server?
postgresql postgresql-9.3 postgresql-9.4 postgresql-9.2 postgresql-9.5
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
3
select version()will include that information (although a bit hard to parse)
– a_horse_with_no_name
Nov 19 '18 at 14:55
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30
add a comment |
i am trying to write a SQL function that determines if the Postgres Server is running on windows, is that possible, or is there a way to get the platform of a running Server?
postgresql postgresql-9.3 postgresql-9.4 postgresql-9.2 postgresql-9.5
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
i am trying to write a SQL function that determines if the Postgres Server is running on windows, is that possible, or is there a way to get the platform of a running Server?
postgresql postgresql-9.3 postgresql-9.4 postgresql-9.2 postgresql-9.5
postgresql postgresql-9.3 postgresql-9.4 postgresql-9.2 postgresql-9.5
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
asked Nov 19 '18 at 14:50
ZORRO_BLANCO
451517
451517
3
select version()will include that information (although a bit hard to parse)
– a_horse_with_no_name
Nov 19 '18 at 14:55
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30
add a comment |
3
select version()will include that information (although a bit hard to parse)
– a_horse_with_no_name
Nov 19 '18 at 14:55
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30
3
3
select version() will include that information (although a bit hard to parse)– a_horse_with_no_name
Nov 19 '18 at 14:55
select version() will include that information (although a bit hard to parse)– a_horse_with_no_name
Nov 19 '18 at 14:55
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30
add a comment |
2 Answers
2
active
oldest
votes
You can simply use select version()
I tried it on an Linux Alpine server (through a Docker container) and got this:
test=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 9.6.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit
(1 row)
You can have more informations on postgres system informations functions here https://www.postgresql.org/docs/current/functions-info.html
Hope it'll help you !
answered Nov 19 '18 at 18:27
SofienM
916
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
add a comment |
This is the code I wroteand used at the end, it works great on Postgres 11 version:
CREATE OR REPLACE FUNCTION GetPLatform()
RETURNS varchar
AS
$$
declare platform varchar;
begin
SELECT CASE
WHEN OSVersion.OS LIKE '%w64%' THEN 'windows'
WHEN OSVersion.OS LIKE '%w32%' THEN 'windows'
WHEN OSVersion.OS LIKE '%mingw%' THEN 'windows'
WHEN OSVersion.OS LIKE '%visual studio%' THEN 'windows'
WHEN OSVersion.OS LIKE '%linux%' THEN 'linux'
WHEN OSVersion.OS LIKE '%mac%' THEN 'mac'
ELSE
'UNKNOWN'
END into platform
FROM (SELECT
substr(substr(version(), strpos(version(), ' on ')+3), 1,
strpos(substr(version(), strpos(version(), ' on ')+3),
', compiled by')-1) as OS)
as OSVersion;
return platform;
end;
$$
LANGUAGE PLPGSQL;
select GetPLatform()
You can adjust it as you want for other platforms...
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
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%2f53377126%2fhow-to-know-on-what-os-platform-the-postgresql-server-runns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can simply use select version()
I tried it on an Linux Alpine server (through a Docker container) and got this:
test=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 9.6.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit
(1 row)
You can have more informations on postgres system informations functions here https://www.postgresql.org/docs/current/functions-info.html
Hope it'll help you !
answered Nov 19 '18 at 18:27
SofienM
916
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
add a comment |
You can simply use select version()
I tried it on an Linux Alpine server (through a Docker container) and got this:
test=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 9.6.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit
(1 row)
You can have more informations on postgres system informations functions here https://www.postgresql.org/docs/current/functions-info.html
Hope it'll help you !
answered Nov 19 '18 at 18:27
SofienM
916
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
add a comment |
You can simply use select version()
I tried it on an Linux Alpine server (through a Docker container) and got this:
test=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 9.6.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit
(1 row)
You can have more informations on postgres system informations functions here https://www.postgresql.org/docs/current/functions-info.html
Hope it'll help you !
answered Nov 19 '18 at 18:27
SofienM
916
You can simply use select version()
I tried it on an Linux Alpine server (through a Docker container) and got this:
test=> select version();
version
-------------------------------------------------------------------------------------------------
PostgreSQL 9.6.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 6.2.1) 6.2.1 20160822, 64-bit
(1 row)
You can have more informations on postgres system informations functions here https://www.postgresql.org/docs/current/functions-info.html
Hope it'll help you !
answered Nov 19 '18 at 18:27
SofienM
916
answered Nov 19 '18 at 18:27
SofienM
916
answered Nov 19 '18 at 18:27
SofienM
916
answered Nov 19 '18 at 18:27
SofienM
916
916
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
add a comment |
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
I know the version() function and this is what I thought too, i wanted something more specific without parsing, but thanks for the answer
– ZORRO_BLANCO
Nov 20 '18 at 9:31
add a comment |
This is the code I wroteand used at the end, it works great on Postgres 11 version:
CREATE OR REPLACE FUNCTION GetPLatform()
RETURNS varchar
AS
$$
declare platform varchar;
begin
SELECT CASE
WHEN OSVersion.OS LIKE '%w64%' THEN 'windows'
WHEN OSVersion.OS LIKE '%w32%' THEN 'windows'
WHEN OSVersion.OS LIKE '%mingw%' THEN 'windows'
WHEN OSVersion.OS LIKE '%visual studio%' THEN 'windows'
WHEN OSVersion.OS LIKE '%linux%' THEN 'linux'
WHEN OSVersion.OS LIKE '%mac%' THEN 'mac'
ELSE
'UNKNOWN'
END into platform
FROM (SELECT
substr(substr(version(), strpos(version(), ' on ')+3), 1,
strpos(substr(version(), strpos(version(), ' on ')+3),
', compiled by')-1) as OS)
as OSVersion;
return platform;
end;
$$
LANGUAGE PLPGSQL;
select GetPLatform()
You can adjust it as you want for other platforms...
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
add a comment |
This is the code I wroteand used at the end, it works great on Postgres 11 version:
CREATE OR REPLACE FUNCTION GetPLatform()
RETURNS varchar
AS
$$
declare platform varchar;
begin
SELECT CASE
WHEN OSVersion.OS LIKE '%w64%' THEN 'windows'
WHEN OSVersion.OS LIKE '%w32%' THEN 'windows'
WHEN OSVersion.OS LIKE '%mingw%' THEN 'windows'
WHEN OSVersion.OS LIKE '%visual studio%' THEN 'windows'
WHEN OSVersion.OS LIKE '%linux%' THEN 'linux'
WHEN OSVersion.OS LIKE '%mac%' THEN 'mac'
ELSE
'UNKNOWN'
END into platform
FROM (SELECT
substr(substr(version(), strpos(version(), ' on ')+3), 1,
strpos(substr(version(), strpos(version(), ' on ')+3),
', compiled by')-1) as OS)
as OSVersion;
return platform;
end;
$$
LANGUAGE PLPGSQL;
select GetPLatform()
You can adjust it as you want for other platforms...
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
add a comment |
This is the code I wroteand used at the end, it works great on Postgres 11 version:
CREATE OR REPLACE FUNCTION GetPLatform()
RETURNS varchar
AS
$$
declare platform varchar;
begin
SELECT CASE
WHEN OSVersion.OS LIKE '%w64%' THEN 'windows'
WHEN OSVersion.OS LIKE '%w32%' THEN 'windows'
WHEN OSVersion.OS LIKE '%mingw%' THEN 'windows'
WHEN OSVersion.OS LIKE '%visual studio%' THEN 'windows'
WHEN OSVersion.OS LIKE '%linux%' THEN 'linux'
WHEN OSVersion.OS LIKE '%mac%' THEN 'mac'
ELSE
'UNKNOWN'
END into platform
FROM (SELECT
substr(substr(version(), strpos(version(), ' on ')+3), 1,
strpos(substr(version(), strpos(version(), ' on ')+3),
', compiled by')-1) as OS)
as OSVersion;
return platform;
end;
$$
LANGUAGE PLPGSQL;
select GetPLatform()
You can adjust it as you want for other platforms...
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
This is the code I wroteand used at the end, it works great on Postgres 11 version:
CREATE OR REPLACE FUNCTION GetPLatform()
RETURNS varchar
AS
$$
declare platform varchar;
begin
SELECT CASE
WHEN OSVersion.OS LIKE '%w64%' THEN 'windows'
WHEN OSVersion.OS LIKE '%w32%' THEN 'windows'
WHEN OSVersion.OS LIKE '%mingw%' THEN 'windows'
WHEN OSVersion.OS LIKE '%visual studio%' THEN 'windows'
WHEN OSVersion.OS LIKE '%linux%' THEN 'linux'
WHEN OSVersion.OS LIKE '%mac%' THEN 'mac'
ELSE
'UNKNOWN'
END into platform
FROM (SELECT
substr(substr(version(), strpos(version(), ' on ')+3), 1,
strpos(substr(version(), strpos(version(), ' on ')+3),
', compiled by')-1) as OS)
as OSVersion;
return platform;
end;
$$
LANGUAGE PLPGSQL;
select GetPLatform()
You can adjust it as you want for other platforms...
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
edited Nov 20 '18 at 10:36
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
answered Nov 20 '18 at 10:09
ZORRO_BLANCO
451517
451517
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53377126%2fhow-to-know-on-what-os-platform-the-postgresql-server-runns%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
3
select version()will include that information (although a bit hard to parse)– a_horse_with_no_name
Nov 19 '18 at 14:55
That's probably the best you will get with SQL. Use PL/Perl or PL/Python for something better.
– Laurenz Albe
Nov 19 '18 at 17:38
exactly the problem with version that it is a little bit hard to parse, but thanks
– ZORRO_BLANCO
Nov 20 '18 at 9:30