Partha, Luc, Paul, and Michael,
Thanks for the excellent pointers, and especially Partha for the wonderfully detailed example. I have Linux, Solaris, and Windows platforms available, and I'm embarassed because it looks like I didn't do enough research before posting. You have put me on the right road, though.
ed
----- Original Message -----
Sent: Saturday, October 18, 2003 10:39 PM
Subject: [NOVICE] Novice dumb questions.
Hi,
I have a newbie question, I have read the README, documentation, and web page but could not find a clue. I have much SQL and relational experience with a variety of vendor products, I don't need SQL or relational design tutorials, I think I need a document like "Postgresql for the Experienced SQL Programmer/Analyst".
Most importantly, need to know which utilities I should download to create my database and develop my queries and stored procedures.
I need utilities that can:
1) Create databases, create and edit tables, and view current table and column definitions,
2) Create and edit stored procedures,
3) Test SQL (I do know about isql.exe)
I also need documentation about maintaining foreign keys, and ensuring referential integrity using those foreign keys.
If anybody can point me to the right sources I would be grateful.
Thanks,
ed