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