zeldor.biz

Linux, programming and more

Copyright © 2023
Log in

CentOS 8 install PostgreSQL 12

January 3, 2020 by Igor Drobot Leave a Comment

CentOS 8 has PostgreSQL within the default repositories but its’ a bit outdated – currently during writing of this post, it’s the version: 10.6.
The currently official version of PostgreSQL is version: 12.1

So this instruction was written to install the current actual version of PostgreSQL 12.1 on CentoOS 8 system.

Let’s get started!

[Read more…]

Filed Under: Linux Tagged With: CentOS, Database, postgresql

Postgresql

August 26, 2010 by Igor Drobot Leave a Comment

 

Some basic postgre commands:




\d [NAME] describe table, index, sequence, or view \d{t|i|s|v|S} [PATTERN] (add "+" for more detail) list tables/indexes/sequences/views/system tables \da [PATTERN] list aggregate functions \db [PATTERN] list tablespaces (add "+" for more detail) \dc [PATTERN] list conversions \dC list casts \dd [PATTERN] show comment for object \dD [PATTERN] list domains \df [PATTERN] list functions (add "+" for more detail) \dg [PATTERN] list groups \dn [PATTERN] list schemas (add "+" for more detail) \do [NAME] list operators \dl list large objects, same as \lo_list \dp [PATTERN] list table, view, and sequence access privileges \dT [PATTERN] list data types (add "+" for more detail) \du [PATTERN] list users \l list all databases (add "+" for more detail)

Filed Under: Linux Tagged With: Database, postgresql, SQL