PostgreSQL – Get Database Version

ByAdmin

To get the version of your PostgreSQL database, you can use the SQL query below when connected to the database:

SELECT version();

When you run this query, it will return a result similar to the following:

PostgreSQL x.x.x on x86_64-pc-linux-gnu, compiled by ...

In the result, “x.x.x” represents the PostgreSQL version number. It also provides information about the platform and compilation details.

Alternatively, you can use the pg_version system view to retrieve version information programmatically:

SELECT version_num, version() AS full_version FROM pg_catalog.pg_version;

This query will return the version number in a structured format as well as the full version string.

Similar Posts

PostgreSQL – JSON_OBJECT_KEYS Function

ByAdmin

You can use the json_object_keys function to extract the keys (field names) from a JSON object in PostgreSQL database. This function takes a JSON object as its argument and returns a set of text values representing the keys in the JSON object. Here is the basic syntax for the json_object_keys function: sqlCopy code json_object_keys(json_object) where…

PostgreSQL – How to Disable(Lock) a User

ByAdmin

You can disable a user account in PostgreSQL database by revoking their login privileges. Disabling a user prevents them from connecting to the PostgreSQL database server. Here’s the basic syntax to revoke login privileges from a user globally: ALTER USER username NOLOGIN; Where username is the name of the user you want to lock/disable. By…

PostgreSQL – How to Convert String to Date

ByAdmin

You can convert a string to a date using the TO_DATE function in PostgreSQL. This function allows you to specify the input string, the format of the string, and it will return a date accordingly. The general syntax of the TO_DATE function is as follows: TO_DATE(input_string, format_string) Here’s an example of using SELECT TO_DATE(‘2023-08-31’, ‘YYYY-MM-DD’);…

PostgreSQL – How to Refresh a Materialized View

ByAdmin

You can refresh the data in a materialized view using the REFRESH MATERIALIZED VIEW statement in PostgreSQL database. A materialized view stores a snapshot of the data from the underlying tables, and this data can become stale over time. The REFRESH MATERIALIZED VIEW command allows you to update the materialized view with the latest data…

PostgreSQL – How to Change Role within a Database Session

ByAdmin

You can change the current role within a database session in PostgreSQL database using SET ROLE statement . Changing the role allows you to temporarily assume the permissions and privileges associated with a different role, which can be useful for specific tasks or actions that require different access rights. This can be particularly helpful in…