Re: [GENERAL] 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
:::::::::::::::::::::::::::::::::::::::::::::::::