The previous article explained how to create and drop tables using the psql client.
Now we'll explore adding columns and rows (records) to our database's tables.
This article will explain how to create and drop database tables using the psql client.
Many web frameworks, such as Ruby on Rails, handle creation and access to database tables automatically. But it's a good idea to learn the basics of working with them manually; also, not everyone running a postgres server will use it in conjunction with a web framework.
Following part 2, this article addresses some security-related concerns affecting postgres servers open to remote TCP connections.
Following part 1, this article explains how to configure our postgres server for less restricted local and remote TCP connections.
For a full treatment, refer to Chapter 21 in the official documentation.
Following installation, access to our PostgreSQL database server is highly restricted owing to its default configuration — this was first explained in the local connections as postgres article.
The present article and the next two will explain how to enable postgres for less restricted local and remote connections, a necessity if we're going to use it as the datastore for our web applications, or connect to it remotely with a database admin tool.
Ruby on Rails and PHP are popular web application frameworks; both commonly make use of a database server on the back-end.
This article will cover installation of the packages needed to integrate PostgreSQL with Ruby on Rails and a standard PHP install.
In this article, we'll connect to the database server as the "postgres" role, using the psql client software for the first time.
Following from the PostgreSQL installation article, we now take a look at some important concepts you will need to be familiar with when working with PostgreSQL.
As such, we'll introduce access control and terms such as roles, attributes and privileges.
Installation of PostgreSQL on Ubuntu Hardy is easily accomplished with the 'aptitude' package manager.
This article will work through the installation process and some configuration changes suggested for a typical setup.