pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: SWagner17 <SWagner17@compuserve.com>
To: ifacesPsql <pgsql-interfaces@postgreSQL.org>
Subject: [INTERFACES] What is the right interface???
Date: Sun, 22 Nov 1998 13:03:11 -0500
Message-ID: <199811221303_MC2-6121-C8C2@compuserve.com> (raw)

>I'm new in Postgresql and I need to make a simple user interface
>(input/query form).  I don't know python, java, tk/tcl, OpenGL or perl,
>altough I'm a fairly good C/C++/shell programmer.


The easiest way to query your database is the following:
create a file myQuery.sql:

## QUERY/SQL
## Usage: myQuery.sql	"x.col1 = CONDITION"
## 
psql myDatabase -c "select 
	x.col1,
    	y.col2
    from
	xTable x,
	yTable y
    where
	x.fkey = y.key
	AND $*
    order by x.col1"
// eof--------------------
and make it executable. 
Of couse this not very flexible, and not usable for inserting data.




view thread (4+ messages)

Message-ID: <199811221303_MC2-6121-C8C2@compuserve.com>
Permalink:  ../199811221303_MC2-6121-C8C2@compuserve.com/
Also on:    postgresql.org/message-id/199811221303_MC2-6121-C8C2@compuserve.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: SWagner17@compuserve.com
  Subject: Re: [INTERFACES] What is the right interface???
  In-Reply-To: <199811221303_MC2-6121-C8C2@compuserve.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox