How to integrate Postgresql db with Django,so that data will be retrieved from that postgresql db table and show it on browser via html

django 1.4 version

postgresql 9.1 version

I have successfully loaded all the html files and css on browser using django.

Now  i have some tables in postgresql ,which i need to integrate it with django and .html files so that data will be read and execute both from html file inputs and database table.

what are the steps to achieve this ?

the home.html contains the macid,hostname,blacklisted etc whatever are there in postgresql table.

i just need to connect and file up those blank spaces in html with data from postgresql table.

for ex:

my folder structure is

>folder

>mysite

>app

            -static

                -style.css

                -main.css

            -templates

             -home.html

            -init.py and init.pyc

            -models.py and models.pyc

            -test.py

            -views.py

        >mysite

         -init.py

         -settings.py and settings.pyc

         -urls.py and urls.pyc

         -views.py and views.pyc

         -wsgi.py

>mysite.db

>manage.py    

and in postgresql the table name is device_table

and its contents are:

CREATE TABLE device_table

(

  serial_no serial NOT NULL,

  macid character varying(100) NOT NULL,

  date_time_of_installation timestamp without time zone,

  blacklisted boolean,

  activated integer,

  deactivated boolean,

  reason character varying(500),

  hostname character varying(255),

  host_ip character varying(50),

  agent_version character varying(75),

  CONSTRAINT device_table_pkey PRIMARY KEY (macid)

)

WITH (

  OIDS=FALSE

);

ALTER TABLE device_table OWNER TO postgres;

Note:I have created models.py by running inspectdb command.

Waiting for a solution..apart from solutions any guide/advice/suggestion are mostly welcome

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a911944c-6adc-4e91-8f93-e9de6c664938%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.