Re: [GENERAL] TESTING the DATABASE

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