BDL1_28022010.pdf

rentacar-> \?

General

\copyright show PostgreSQL usage and distribution terms

\g [FILE] or ; execute query (and send results to file or |pipe)

\h [NAME] help on syntax of SQL commands, * for all commands

\q quit psql

Query Buffer

\e [FILE] edit the query buffer (or file) with external editor

\ef [FUNCNAME] edit function definition with external editor

\p show the contents of the query buffer

\r reset (clear) the query buffer

\s [FILE] display history or save it to file

\w FILE write query buffer to file

Input/Output

\copy ... perform SQL COPY with data stream to the client host

\echo [STRING] write string to standard output

\i FILE execute commands from file

\o [FILE] send all query results to file or |pipe

\qecho [STRING] write string to query output stream (see \o)

Informational

(options: S = show system objects, + = additional detail)

rentacar-> \h

Available help:

ABORT ANALYZE

CREATE TABLE DROP OPERATOR FAMILY NOTIFY

ALTER AGGREGATE BEGIN

CREATE TABLE AS DROP OWNED

PREPARE

ALTER CONVERSION CHECKPOINT

CREATE TABLESPACE DROP ROLE

PREPARE TRANSACTION

ALTER DATABASE CLOSE

CREATE TEXT SEARCH CONFIGURATION DROP RULE

REASSIGN OWNED

ALTER DOMAIN CLUSTER

CREATE TEXT SEARCH DICTIONARY DROP SCHEMA

REINDEX

ALTER FOREIGN DATA WRAPPER COMMENT

CREATE TEXT SEARCH PARSER DROP SEQUENCE

RELEASE SAVEPOINT

ALTER FUNCTION COMMIT

CREATE TEXT SEARCH TEMPLATE DROP SERVER RESET

ALTER GROUP COMMIT PREPARED

CREATE TRIGGER DROP TABLE REVOKE

ALTER INDEX COPY

CREATE TYPE DROP TABLESPACE

ROLLBACK

ALTER LANGUAGE CREATE AGGREGATE

CREATE USER DROP TEXT SEARCH CONFIGURATION

ROLLBACK PREPARED

ALTER OPERATOR CREATE CAST

CREATE USER MAPPING DROP TEXT SEARCH DICTIONARY

ROLLBACK TO SAVEPOINT

ALTER OPERATOR CLASS CREATE CONSTRAINT TRIGGER

CREATE VIEW DROP TEXT SEARCH PARSER

SAVEPOINT

ALTER OPERATOR FAMILY CREATE CONVERSION

DEALLOCATE DROP TEXT SEARCH TEMPLATE SELECT

ALTER ROLE CREATE DATABASE

DECLARE DROP TRIGGER SELECT

INTO

ALTER SCHEMA CREATE DOMAIN

DELETE DROP TYPE SET

ALTER SEQUENCE CREATE FOREIGN DATA WRAPPER

DISCARD DROP USER SET

CONSTRAINTS

ALTER SERVER CREATE FUNCTION DROP

AGGREGATE DROP USER MAPPING SET ROLE

ALTER TABLE CREATE GROUP DROP

CAST DROP VIEW SET SESSION

AUTHORIZATION

ALTER TABLESPACE CREATE INDEX DROP

CONVERSION END SET

TRANSACTION

ALTER TEXT SEARCH CONFIGURATION CREATE LANGUAGE DROP

DATABASE EXECUTE SHOW

ALTER TEXT SEARCH DICTIONARY CREATE OPERATOR DROP

DOMAIN EXPLAIN START

TRANSACTION

ALTER TEXT SEARCH PARSER CREATE OPERATOR CLASS DROP

FOREIGN DATA WRAPPER FETCH TABLE

ALTER TEXT SEARCH TEMPLATE CREATE OPERATOR FAMILY DROP

FUNCTION GRANT TRUNCATE

ALTER TRIGGER CREATE ROLE DROP

GROUP INSERT UNLISTEN

ALTER TYPE CREATE RULE DROP

INDEX LISTEN UPDATE

ALTER USER CREATE SCHEMA DROP

LANGUAGE LOAD VACUUM

ALTER USER MAPPING CREATE SEQUENCE DROP

OPERATOR LOCK VALUES

ALTER VIEW CREATE SERVER DROP

OPERATOR CLASS MOVE WITH

rentacar-> \h select

Command: SELECT

Description: retrieve rows from a table or view

Syntax:

[ WITH [ RECURSIVE ] with_query [, ...] ]

SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]

* | expression [ [ AS ] output_name ] [, ...]

[ FROM from_item [, ...] ]

[ WHERE condition ]

[ GROUP BY expression [, ...] ]

[ HAVING condition [, ...] ]

[ WINDOW window_name AS ( window_definition ) [, ...] ]

[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]

[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]

[ LIMIT { count | ALL } ]

[ OFFSET start [ ROW | ROWS ] ]

[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]

[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]

where from_item can be one of:

[ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]

( select ) [ AS ] alias [ ( column_alias [, ...] ) ]

with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]

function_name ( [ argument [, ...] ] ) [ AS ] alias [ ( column_alias [, ...] | column_definition [, ...] ) ]

function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )

from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ]

and with_query is:

with_query_name [ ( column_name [, ...] ) ] AS ( select )

TABLE { [ ONLY ] table_name [ * ] | with_query_name }

\d - pokazuje strukturę tabeli bazy danych

rentacar-> \d

List of relations

Schema | Name | Type | Owner

--------+--------------+-------+---------

public | klienci | table | student

public | miejsca | table | student

public | pracownicy | table | student

public | samochody | table | student

public | wypozyczenia | table | student

(5 rows)

\d pracownicy, \d wypożyczenia - pokaże co jest w tabeli "pracownicy", "wypożyczenia"

rentacar-> \d pracownicy

Table "public.pracownicy"

Column | Type | Modifiers

------------+-----------------------+-----------

nr_prac | integer | not null

imie | character varying(20) | not null

nazwisko | character varying(20) | not null

data_zatr | date | not null

dzial | character varying(20) | not null

stanowisko | character varying(20) | not null

pensja | real |

dodatek | real |

nr_miejsca | integer |

tel | character(16) |

Indexes:

"x4" PRIMARY KEY, btree (nr_prac)

Foreign-key constraints:

"x5" FOREIGN KEY (nr_miejsca) REFERENCES miejsca(nr_miejsca)

Referenced by:

TABLE "wypozyczenia" CONSTRAINT "x9" FOREIGN KEY (nr_prac_wyd)

REFERENCES pracownicy(nr_prac)

rentacar-> \d wypozyczenia

Table "public.wypozyczenia"

Column | Type | Modifiers

-----------------+---------+-----------

nr_wypozyczenia | integer | not null

nr_klienta | integer |

nr_samochodu | integer |

nr_prac_wyd | integer |

nr_prac_odd | integer |

nr_miejsca_wyd | integer |

nr_miejsca_odd | integer |

data_wyd | date | not null

data_odd | date |

kaucja | real |

cena_jedn | real | not null

Indexes:

"x6" PRIMARY KEY, btree (nr_wypozyczenia)

Foreign-key constraints:

"x7" FOREIGN KEY (nr_klienta) REFERENCES klienci(nr_klienta)

"x8" FOREIGN KEY (nr_samochodu) REFERENCES samochody(nr_samochodu)

"x9" FOREIGN KEY (nr_prac_wyd) REFERENCES pracownicy(nr_prac)

rentacar=> \d samochody

Table "public.samochody"

Column | Type | Modifiers

---------------+-----------------------+-----------

nr_samochodu | integer | not null

marka | character varying(20) | not null

model | character varying(16) | not null

rok_produkcji | date | not null

kolor | character varying(16) | not null

poj_silnika | smallint | not null

przebieg | integer | not null

Indexes:

"x2" PRIMARY KEY, btree (nr_samochodu)

Referenced by:

TABLE "wypozyczenia" CONSTRAINT "x8" FOREIGN KEY (nr_samochodu)

REFERENCES samochody(nr_samochodu)

wyświetl wszytko z tabeli klienci

rentacar=> select * from klienci;

------------+-----------+--------------+----------------------+--------------------+---------------------+----------+----------+--------+--------------+------------------

2 | Tomasz | Adamczak | HH 12345678 | Kowalski s.c. | Kwiatowa | 4/9 | Warszawa | 01-900 | 543-123-456 | 246-744-431

3 | Piotr | Malczyk | HF 12445661 | ADA s.c. | Rozana | 9 | Warszawa | 01-878 | 443-133-251 | 216-742-114

4 | Pawel | Fiodorowicz | DD 76545321 | Krawiectwo | Armii Krajowej | 22A | Warszawa | 01-200 | 555-233-256 | 144-342-116

11 | Anna | Kowalska | KJ 98765412 | Modniarstwo | Powstancow Slaskich | 4 | Wroclaw | 37-200 | 422-132-354 | 444-283-901

19 | Rafal | Rafalski | WS 12358672 | Naprawa samochodow | Przemyslowa | 1 | Warszawa | 00-212 | 999-765-120 | 822-324-742

20 | Robert | Nowak | AS 61333699 | Tapicerstwo | Mostowa | 9B | Warszawa | 00-111 | 987-765-333 | 811-311-147

5 | Aniela | Dalgiewicz | | Modna Pani | Bohaterow Getta | 24 | Wroclaw | 37-200 | 456-234-153 | 144-188-415

12 | Krzysztof | Dobrowolski | | Kamieniarstwo | Strzegomska | 124 | Wroclaw | 37-400 | 433-133-332 | 444-285-202

1 | Jan | Kowalski | | | Kochanowskiego | 3 | Wroclaw | 37-300 | | 167-763-239

6 | Joanna | Kwiatkowska | | | Tuwima | 2/5 | Swidnica | 58-100 | | 963-733-231

7 | Bozena | Malinowska | | | Lelewela | 34/1 | Swidnica | 58-100 | | 963-733-231

8 | Tomasz | Nowak | | | Zeromskiego | 5A/8 | Swidnica | 58-100 | | 911-135-536

9 | Krzysztof | Domagala | | | Lesna | 5 | Swidnica | 58-100 | | 922-233-232

10 | Arkadiusz | Doczekalski | | | Lesna | 2 | Swidnica | 58-100 | | 922-233-267

13 | Marcin | Krzykala | | | Konopnickiej | 1/4 | Wroclaw | 37-400 | | 442-211-109

14 | Aneta | Paprocka | | | Tuwima | 2 | Wroclaw | 37-400 | | 442-671-899

15 | Sebastian | Kownacki | | | Glowackiego | 2/9 | Wroclaw | 37-400 | | 423-681-129

16 | Michal | Michalski | | | Kwiatowa | 9/3 | Wroclaw | 37-500 | | 499-621-921

17 | Michal | Szykowny | WW 12398765 | | Lesna | 3 | Warszawa | 00-100 | | 191-221-622

18 | Marcin | Marcinkowski | WQ 14368781 | | Okrezna | 33 | Warszawa | 00-200 | | 122-127-647

21 | Mariusz | Dolata | | Kwiaty | Kochanowskiego | 3 | Wroclaw | 37-300 | 167-763-254 | 224-444-224

(21 rows)

wyświetl tylko imie z tabelki klienci

rentacar=> select imie from klienci;

imie

-----------

Tomasz

Piotr

Pawel

Anna

Rafal

Robert

Aniela

Krzysztof

Jan

Joanna

Bozena

Tomasz

Krzysztof

Arkadiusz

Marcin

Aneta

Sebastian

Michal

Marcin

Mariusz

(21 rows)

wyświetl imie i nazwisko z tabeli klienci

rentacar=> select imie, nazwisko from klienci;

imie | nazwisko

-----------+--------------

Tomasz | Adamczak

Piotr | Malczyk

Pawel | Fiodorowicz

Anna | Kowalska

Rafal | Rafalski

Robert | Nowak

Aniela | Dalgiewicz

Krzysztof | Dobrowolski

Jan | Kowalski

Joanna | Kwiatkowska

Bozena | Malinowska

Tomasz | Nowak

Krzysztof | Domagala

Arkadiusz | Doczekalski

Marcin | Krzykala

Aneta | Paprocka

Sebastian | Kownacki

Michal | Michalski

Michal | Szykowny

Marcin | Marcinkowski

Mariusz | Dolata

(21 rows)

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: