PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II

Started by Himmet Karamanalmost 23 years ago4 messagesdocsgeneral
Jump to latest
#1Himmet Karaman
karamanhi@itu.edu.tr
docsgeneral

Can anyone help me about how can i configure it to be able to choose
only some types of data (for example to enter the name of the city to
one of the columns [or fields] the one who is entering th data must be
able to choose only the cities that i want to be added and how can i
make it possible to seem like a drop down menu in pgAdmin II or in
pgAccess it while someone entering data to the postgresql) while
entering new data to postgresql in pgadmin II or in pgaccess .....
Thank you .....

--

:::::::::::::::::::::::::::::::::::::::::::::::::
Research Assistant
Himmet KARAMAN
Istanbul Technical University
Geodesy and Photogrammetry Eng. Department
34469 Maslak/ISTANBUL TURKEY
Tel : +90 (212) 285 67 83
Fax : +90 (212) 285 34 20
Web : http://atlas.cc.itu.edu.tr/~karamanhi
:::::::::::::::::::::::::::::::::::::::::::::::::

#2Tim Ellis
pvspam-postgres@hacklab.net
In reply to: Himmet Karaman (#1)
docsgeneral
Re: PLEASE HELP ME URGENT about choosing only the ones

On Thu, 2003-04-10 at 06:06, Himmet Karaman wrote:

Can anyone help me about how can i configure it to be able to choose
only some types of data (for example to enter the name of the city to
one of the columns [or fields] the one who is entering th data must be
able to choose only the cities that i want to be added and how can i

You want code tables. You can enforce the referential integrity via
triggers or, if you like living on the edge, in the application.

This isn't a difficult problem, but nor is it the type of thing you'll
get resolved on mailing lists. You need a database developer, or you
need to get some books and become one yourself.

--
Tim Ellis
Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org)
If this helped you, http://svcs.affero.net/rm.php?r=philovivero

#3Juraj Fedel
fedel@pobox.sk
In reply to: Tim Ellis (#2)
docsgeneral
Re: [ADMIN] PLEASE HELP ME URGENT about choosing only the ones

On Thu, Apr 10, 2003 at 11:13:05AM -0700, Tim Ellis wrote:

This isn't a difficult problem, but nor is it the type of thing you'll
get resolved on mailing lists. You need a database developer, or you
need to get some books and become one yourself.

Is there some online books (or other manual) about developing databases?
Juraj

#4Jeff Fitzmyers
jeff@cloverpub.com
In reply to: Juraj Fedel (#3)
docsgeneral
Re: [ADMIN] PLEASE HELP ME URGENT about choosing only the ones

A few articles to help get started:
http://phpbuilder.com/columns/index.php3?cat=1&subcat=1

I would also read the docs:
http://www.postgresql.org/docs/
view.php?version=7.3&idoc=0&file=index.html

Have fun, Jeff

Show quoted text

On Thu, Apr 10, 2003 at 11:13:05AM -0700, Tim Ellis wrote:

This isn't a difficult problem, but nor is it the type of thing you'll
get resolved on mailing lists. You need a database developer, or you
need to get some books and become one yourself.

Is there some online books (or other manual) about developing
databases?
Juraj

---------------------------(end of
broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly