Postgres Pro
Downloads
Home   >   mailing lists

Thread: Novice dumb questions.

Novice dumb questions.

From
"Ed Fair"
Date:
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
 

Re: Novice dumb questions.

From
"Ed Fair"
Date:
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 -----
From: Ed Fair
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