[GENERAL] Getting Primary * Foreign Key Information?

How do I get primary and foreign key data for a table? Are there Postgres functions that return this information? What tables should I join to pg_index and pg_trigger to get this information? Thanks for any assistance. ---(end of broadcast)---

[GENERAL] Re: a script that queries db periodically

Thank you for all your response. Not only do I benefit from your response, but hopefully others benefit as well. Thanks again. - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr

[GENERAL] How to display stored image on web page?

Now that I've stored several jpg's in my database as large objects, I'm trying to display them on a web page using a java servlet. Im my servlet, I've changed the content type to image/jpeg - response.setContentType("image/jpg"); When the web page is loaded, all I see is the ID number of the imag

[GENERAL] Postmaster Won't Start

whenever I attempt to start the postmaster, I get the following error: FindBackend: found "/usr/bin/postgres" using argv[0] FATAL: StreamServerPort: bind() failed: errno=13 Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.)and retry.