Re: postgresql query

[Sitanshu Nanda <sitansu_nanda@xxxxxxxxx>]

Hi Prasad,
    just type pgaccess in the command prompt to start
the GUI based front end for Postgres. But before that
you must kill the postmaster running if any, then restart again as
background process with -i option
as below
       $ postmaster -i -p 5432 &
the -p option for a particular port. Then open your 
database in pgaccess and enjoy .....

   You can also use java as front end which I am using
and i find it quite interesting to code in java. But
to use JDBC Driver you have to have some knowledge
about java and JDBC Driver. If you are interested
in JDBC you can contact me in this address
  sitansu@xxxxxxxxxxx

O.K Bye
Sitanshu


- --- Prasad Tripurari <tprsd1@xxxxxxxxx> wrote:
> Hi Anand,
> 
>   Thank you for your info. I doing well with
> postgresql with your
> suggestion. Please send details to run PGACCESS. One
> more thing, I want
> frontend as a CUI based forms. Is it possible in
> postgresql. If not any
> CUI base frontend is available for backend of
> postgresql.

> > Bye
> > Anand

> > Sitanshu Nanda wrote:

 > I have loaded Red Hat linux 5.2 in my machine.
 >  Postgresql comes with this CD you don.t have to
 > Install it again. Only some setup is required to
> run the package. The
> steps are :
>    Initialise these two variables
>      PGDATA and PGLIB as
>       PGDATA=/home/sitansu/data(I have done this
>  for my data)
> >       PGlIB=/usr/lib/pgsql
>  (Since the library is in this directory)
>  export PGLIB PGDATA
>  You can do this in any start up file
>    like .bash_prfile or .profile etc.
>  > Then run initdb
>     $initdb
>    Then run postmaster in background
 >     $postmaster &
 >      $createdb mydb
>  It will create a database
>       $ psql mydb
>  It will connect to the database and show you a
>  prompt
>
> you can then give any SQL command in this prompt
>  For example
> mydb=>create table employee (.......
>
> But I don't know anythong about SuSE linux 6.0
> If this information help you then I will
>  write more on How to run pgaccess.

> O.K Bye
> > >
- --- Anand Raman <anandram@xxxxxxxxxxxxxxx>
> wrote:
> > > > Hi all
> > > > Did any one of u manage to get postgreSQL
> > working
> > > > for SuSE linux 6.0 (
> > > > 2.0.36).
> > > > I need some pointers for my installation is
> > always
> > > > failing on the
> > > > configure and install stage
> > > > Please let me know
> > > > Thanx
> > > > Anand
> > > >
> > > >
> >
> --------------------------------------------------------------------
> > > > For more information on Linux in India visit
> > > > http://www.linux-india.org/
> > > > Linux India is NOT a forum for
> > > > Microsoft/India/Pakistan/US/UK bashing.
> > > > Flame baits will not be tolerated.  If you can
> > > > appreciate satire read
> > > > http://www.templetons.com/brad/emily.html
> > > >
> > >
> > >
> >
> _________________________________________________________
> > > Do You Yahoo!?
> > > Get your free @yahoo.com address at
> > http://mail.yahoo.com
> > >
> > >
> >
> --------------------------------------------------------------------
> > > For more information on Linux in India visit
> > http://www.linux-india.org/
> > > Linux India is NOT a forum for
> > Microsoft/India/Pakistan/US/UK bashing.
> > > Flame baits will not be tolerated.  If you can
> > appreciate satire read
> > > http://www.templetons.com/brad/emily.html
> > 
> > 
> >
> --------------------------------------------------------------------
> > For more information on Linux in India visit
> > http://www.linux-india.org/
> > The SiS 6215 HOWTO resides at
> > http://www.linux-india.org/sis
> > 
> 
> ===
> Regards
> 
> T Prasad
> SYSTEMS ANALYST
> MARGADARSI COMPUTERS
> Email: tprsd1@xxxxxxxxx
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
> 
> 
> --------------------------------------------------------------------
> For more information on Linux in India visit
> http://www.linux-india.org/
> 

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


- --------------------------------------------------------------------
For more information on Linux in India visit http://www.linux-india.org/
Please do not post HTML email to this mailing list.  HTML mails will be
thoroughly ignored and derisively sniggered at in private.

------------------------------