Обсуждение: TESTING the DATABASE

Поиск
Список
Период
Сортировка

TESTING the DATABASE

От
Himmet Karaman
Дата:
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 ...

--

:::::::::::::::::::::::::::::::::::::::::::::::::
  Research Assistant
  Himmet KARAMAN
  Istanbul Technical University
  Geodesy and Photogrammetry Eng. Department
  34469 Maslak/ISTANBUL TURKEY
  Tel    : +90 (212) 285 67 83
  Fax    : +90 (212) 285 34 20
  Web    : http://atlas.cc.itu.edu.tr/~karamanhi
:::::::::::::::::::::::::::::::::::::::::::::::::




Re: [GENERAL] TESTING the DATABASE

От
"Nigel J. Andrews"
Дата:
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