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?

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?

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?

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

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

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

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 |

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...

edited Nov 20 '18 at 10:36

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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

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

Name

Required, but never shown

2 Answers
2

active

oldest

votes

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 |

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

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

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...

edited Nov 20 '18 at 10:36

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...

edited Nov 20 '18 at 10:36

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...

edited Nov 20 '18 at 10:36

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...

edited Nov 20 '18 at 10:36

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

add a comment |

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');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk