1. How to execute SQL commands from a file in postgresql?
(Databases/pgsql)

Question: How to execute SQL commands from a file in postgresql? In my case I had a .sql file with hundreds of insert statements and I wanted to run all of them, I was left with two options namely manually ...

2. Editing the pg_hba.conf file on a postgresql database server so that a specific (other) server will be able to connect to the postgresql database server
(Databases/pgsql)

Editing the pg_hba.conf file on a postgresql database server so that a specific (other) server will be able to connect to the postgresql database server. Example: Say I have a server where all of my postgresql ...

3. How to export data to a CSV file from a postgres database
(Databases/pgsql)

...  How to import a CSV file into a postgresql?  ...

4. How to export data to a CSV file from a postgres database together with table headings?
(Databases/pgsql)

... file into a postgresql?  ...

5. How to create a backup of a postgres database to a sql file?
(Databases/pgsql)

... to backup a PostgreSQL db. -C = Begin the output with a command to create the database itself and reconnect to the created database. -d = Dump the data as INSERT commands -i = Ignores version mismatch ...

6. How to check what version of Postgresql your running?
(Databases/pgsql)

Question: How to check what version of Postgresql your running?   Answer:  Run the following query: SELECT version(); The result will look as below:                                                ...