postgres@server254:~$ psql -d user1db
Welcome TO psql 8.3.6, the PostgreSQL interactive terminal.
 
Type:  \copyright FOR distribution terms
       \h FOR help WITH SQL commands
       \? FOR help WITH psql commands
       \g OR terminate WITH semicolon TO execute query
       \q TO quit
 
user1db=# create table phbook(person varchar,
user1db(# post varchar, phone char(20));
CREATE TABLE
user1db=# \dt
           Список отношений
 Схема  |  Имя   |   Тип   | Владелец 
--------+--------+---------+----------
 public | phbook | таблица | postgres
(1 запись)
 
user1db=# \d phbook
          Таблица "public.phbook"
 Колонка |        Тип        | Модификаторы 
---------+-------------------+--------------
 person  | character varying | 
 post    | character varying | 
 phone   | character(20)     | 
 
user1db=# insert into phbook(person, post, phone)
user1db-# values('Сергей Иванович', 'директор', '(012) 345-67-89');
INSERT 0 1
user1db=# select * from phbook;
     person      |   post   |        phone         
-----------------+----------+----------------------
 Сергей Иванович | директор | (012) 345-67-89     
(1 запись)
 
user1db=#