Re: TESTING the DATABASE

Hi,
I want to test all part of the database.
If the relations work, and all of the tables are ok, and can i make queries on my database...
i mean can my database do everything wright?
Is there any tool or command to test it?
Thanks again

Nigel J. Andrews wrote:

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?

 

-- 

::::::::::::::::::::::::::::::::::::::::::::::::: 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 
:::::::::::::::::::::::::::::::::::::::::::::::::