Sometimes we may want to create the same table in a database without the data in it by using a different name or we …
Read More »Faruk Erdem
Running an Operating System Command while Connected to Postgres
You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql …
Read More »How To List Tablespaces and Objects in Tablespaces On PostgreSQL
You can use the following command to see the list of tablespaces created. [crayon-677f1a694c951447245827/] You can also use the following script to list …
Read More »How To Encrypt a Column(Like Password) with chkpass On PostgreSQL
We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …
Read More »