Обсуждение: [INTERFACES] What is the right interface???

Поиск
Список
Период
Сортировка

[INTERFACES] What is the right interface???

От
SWagner17
Дата:
>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.