Re: [GENERAL] TESTING the DATABASE - Mailing list pgsql-admin

From Nigel J. Andrews
Subject Re: [GENERAL] TESTING the DATABASE
Date
Msg-id Pine.LNX.4.21.0305150740420.12078-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to TESTING the DATABASE  (Himmet Karaman <karamanhi@itu.edu.tr>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: [GENERAL] TESTING the DATABASE
Next
From: gdid@gmx.de (G. W.)
Date:
Subject: Backup without WAL files with Server shut down