PostgreSQL для чайника. Slackware 12.0

#/etc/rc.d/rc.postgresql start

#su postgres

$ psql -l
List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 postdb    | postgres | SQL_ASCII
 postgres  | postgres | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(4 rows)

$ psql postdb
Welcome to psql 8.3.0, 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
 
postdb=#

postdb=# \dt
          List of relations
 Schema |  Name   | Type  |  Owner
--------+---------+-------+----------
 public | cities  | table | postgres
 public | weather | table | postgres
(2 rows)

postdb=# create table org (kod varchar(80), --код организации
postdb(# name varchar(80) --название организации);

postdb=# copy org (kod, name) from '/media/TEMP/2';
COPY 2

$ cat /media/TEMP/2
КодОрганизация1 ИмяОрганизация1
КодОрганизация2 ИмяОрганизация2

postdb=# select * from org;
              kod              |             name
-------------------------------+-------------------------------
 КодОрганизация1 | ИмяОрганизация1
 КодОрганизация1 | ИмяОрганизация1
 КодОрганизация2 | ИмяОрганизация2
(3 rows)

postdb=# delete from org *;
DELETE 3

postdb=# Truncate org;
TRUNCATE TABLE

postdb=# ALTER TABLE org ADD COLUMN okpo varchar(80);
ALTER TABLE

postdb=# select * from org;
 kod | name | okpo
-----+------+------
(0 rows)

postdb=# ALTER TABLE org DROP COLUMN okpo;
ALTER TABLE

postdb=# ALTER TABLE org RENAME COLUMN okpo TO okpo1;
ALTER TABLE

postdb=# select * from org;
 kod | name | okpo1
-----+------+------
(0 rows)