which is the best interface for postgresql

[nehashri]

hi
can ne1 plz guide me as to which interface is best for posgresql.
i have started using posgrsql recently. i am making a biological database which has a frontend allowing the user to select various option like login, password, organism to view , select perticular option etc., and the backend as postgresql where all the process of submission and sorting will take place. im a bit confused and im not able to decide what should i use as front end to facilitate my process.

plz ne 1 can tell me how to choose the best one to be used in LINUX. which will b suitable for my study
thankin u in adv

[michaelb]

There's no such thing as "the best interface", you choose one that best fits your needs, operating environment, requirements or knowledge.

Avaiable options may include C/C++, Java, PSQL, TCL, PHP, PERL, PYTHON and maybe more (some are subject to compile options)

http://www.postgresql.org/docs/8.0/interactive/client-interfaces.html

http://www.postgresql.org/docs/8.0/static/server-programming.html

[nehashri]

thank u for reply i knew abt these option but was not able to decide which will be better (ok not best) as per my requirement. ur links were of help. i think ill hv 2 study more to select.
thank u

[michaelb]

You may also want to look at some graphical tools that can help you:

http://www.postgresql.org/about/news.716

http://www.amsoftwaredesign.com/index.php

Good luck!

[Michael Raven]

need to specify exactly what you mean by "interface"
for example here www.sqlmanager. net GUI interface to administer and manage PostgreSQL DBMS

[ahammond]

hi
plz ne 1 can tell me how to choose the best one to be used in LINUX. which will b suitable for my study
thankin u in adv

If it's you personally that wants to interface with the database then I'd suggest either the command line interface that comes with postgres called psql. If you want something GUI than check out pgadmin3.

As an aside, if you want to be taken seriously, you might want to take the time to write like you have an education that extends beyond the kindergarten of IRC