Re: postgresql query

[Prasad Tripurari <tprsd1@xxxxxxxxx>]

Hi Sitanshu,

    Thank you for your mail. I am using postgresql, and PGACCESS also
very well with your help. I am interested to use Java. But How to
configures JDBC?
    Is there any CUI based frontend tool in Linux. Because, I want to
run my application in dumb terminal.

    Thankx

Rgds
T Prasad

- --- Sitanshu Nanda <sitansu_nanda@xxxxxxxxx> wrote:
> 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.
> 

===
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/
Please do not post HTML email to this mailing list.  HTML mails will be
thoroughly ignored and derisively sniggered at in private.

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