Home » Search results for 'postgresql'

PostgreSQL – Default Password/Resetting the Default Password

PostgreSQL Default User Password Reset

This post will explain how user accounts by default work in PostgreSQL, and how you can change the default password. PostgreSQL works a bit differently to other database servers like MySQL when it comes to the default behaviour of user accounts, so read on to find out how to manage access as the default PostgreSQL admin user. PostgreSQL uses the system users The default PostgreSQL configuration uses ident for authentication – this method uses the hosts operating systems usernames and compares them against the permissions stored for each database. This means … Read more

Home » Search results for 'postgresql'

How to Switch Active Cluster / Change Port in PostgreSQL in Linux

PostgreSQL Change Active Cluster Default Port

This article will demonstrate how to list the PostgreSQL clusters on your Linux system, and how to switch the active cluster. PostgreSQL is one of the most popular relation database servers. Multiple versions can be installed on the same host, so being able to switch between them is pretty useful. Read on to find out how to do it. What is a Cluster A PostgreSQL cluster is a collection of PostgreSQL databases with a shared configuration, managed. This configuration includes things like the executable that manages the … Read more

Home » Search results for 'postgresql'

How to Import a CSV File to PostgreSQL

PostgreSQL Import CSV File

This tutorial will show you how to import data from a CSV file into a PostgreSQL database table. What is a CSV File A CSV (Comma Separated Values) file is a text file that contains tabulated information. The rows in this data each take up a line in the text file, while the values in each column on each row are separated by a comma – hence, comma-separated. CSV files are versatile. Because the data within is stored as plain text, they can be opened … Read more

Home » Search results for 'postgresql'

How to Export and Back Up PostgreSQL Databases

PostgreSQL Backup Import Export

This tutorial will show you how to export, import, and back up your PostgreSQL clusters and databases. You should regularly back up. It’s one of the most important things you can do as a sysadmin, developer, and even a hobbyist. Losing your data is detrimental to business, and your projects. Losing your family photos sucks too. This article demonstrates the various way to import and export PostgreSQL data so that it can be backed up. This process should be done regularly (or automated!), and performed … Read more

Home » Search results for 'postgresql'

LinuxScrew Guide for Developers Learning PostgreSQL

Learn PostgreSQL Guide

This page serves as the index for our PostgreSQL tutorials. It will be updated as new articles in the series are added. This guide is intended for developers who are just getting started with PostgreSQL and are looking for a simple resource to get them up and running. PostreSQL Guide Introduction: What is PostgreSQL? Why Use It ?

Home » Search results for 'postgresql'

PostreSQL Guide Introduction: What is PostgreSQL? Why Use It ?

PostgreSQL Introduction - What is PostgreSQL

This article is part of the LinuxScrew Guide for Developers Learning PostgreSQL. PostgreSQL is a relational database management system. It is similar to other networked SQL database servers like MySQL/MariaDB and Microsoft SQL, but there are some key differences in features and functionality. PostgreSQL vs Other Database Systems You can see a comparison of PostgreSQL and other database systems here. In short, while MySQL is the most popular open source database system, PostgreSQL is more advanced. PostgreSQL is object oriented, can store a larger number of types … Read more

Home » Search results for 'postgresql'

MySQL vs MariaDB vs MongoDB vs PostgreSQL vs SQLite vs MS SQL – Which to Choose?

Which database to Choose

There is a lot of weird-sounding language around databases. Most of it centers on the names of the popular database software which is available. It can make it tough to choose. Each strangely named database solution offers features making it suitable for different tasks. This article should shed some light on what’s what. SQL Is a Language SQL (pronounced ESS-QUE-ELL or sequel depending on which side of the raging debate you side with). It stands for Structured Query Language. It is not a piece of software – it’s the … Read more

Home » Search results for 'postgresql'

Postgresql: show tables, show databases, show columns, describe table

PostgreSQL is one of the best database engines for an average web project and many who moves to psql from MySQL (for example) often ask the following questions: What is the analog of “show tables” in Postgres? How can I get the list of databases in Postgres like “show databases” in MySQL? In this quick tutorial, we’ll answer these questions, along with some other common commands which are useful. PostgreSQL doesn’t work with original MySQL commands, but it gives similar functionality with its own commands: … Read more

Home » Search results for 'postgresql'

How to Run an SQL File in MySQL (or MariaDB) on Linux/Ubuntu

How to Run a SQL File in MySQL/MariaDB on Linux/Ubuntu

Here is an article outlining several methods for running SQL files in MySQL on Linux/Ubuntu. Whether you’re installing a package, following a tutorial, or restoring a backup – it’s useful to be able to execute an SQL script from a file and have it do all of the work for you, rather than having to type it all out. Most GUI database managers have a simple import option prominently displayed in the menu bar – so here’s how to do it from the command line … Read more

Home » Search results for 'postgresql'

How to Read CSV Files in Python, With Examples

Python read from csv file

This article will show you how to read CSV (Comma Separated Values) files in the Python programming language, with examples. What is CSV (Comma Separated Values) CSV (Comma Separated Values) is a format for storing and transmitting data, usually in a text file, in which the individual values are separated by a comma (,). Each row in a CSV file represents an individual record containing multiple comma separated values. A CSV file looks like this: name,age,favourite colour Fred,54,green Mary,31,pink Steve,12,orange Above, the CSV describes three people, with information … Read more