Re: [GENERAL] TESTING the DATABASE

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема Re: [GENERAL] TESTING the DATABASE
Дата
Msg-id Pine.LNX.4.21.0305150740420.12078-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответ на TESTING the DATABASE  (Himmet Karaman <karamanhi@itu.edu.tr>)
Список pgsql-admin
On Thu, 15 May 2003, Himmet Karaman wrote:

> Hello to all,
> Is there anyone who can explain me briefly, how can I test the database
> that I created using PostgreSQL?
> Thanks a lot for the time you spent ...


Well, at a basic level...

$ psql mydbname
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

mydbname=> create table mytable ( a integer );
mydbname=> insert into mytable (a) values (1);
mydbname=> select * from mytable;
 a
---
 1
(1 row)

mydbname=>\q


The question is, what is it you want to test?


--
Nigel J. Andrews


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: [GENERAL] TESTING the DATABASE
Следующее
От: gdid@gmx.de (G. W.)
Дата:
Сообщение: Backup without WAL files with Server shut down