How to add a column to PostgreSQL table

Below example adds a new column of type varchar and length 10 characters to a PostgreSQL
database table:

psql> ALTER TABLE [table_name] ADD COLUMN [column_name] VARCHAR(10);

You can run it from psql, phpPgAdmin or any other admin tool