Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
tool to create postgres er diagram from sql script
there are quite few out there, but I use http://www.codework.com/dbvis/dbversion51.html- wwtf
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
Triggers -> Comparing NEW to OLD
Greetings, I'm creating a history table that will record any changes to a record. Problem is that I have to update multiple records in one shot where some of the records may or may not contain changes. I fire a trigger after Insert/Update and the trigger function looks like this. I was hoping...- wwtf
- Thread
- Replies: 0
- Forum: PostgreSQL Inc.: PostgreSQL
-
Help with creating a view
$query = 'SELECT f.id, f.top_pos, f.left_pos, f.height, f.width, f.type, CASE WHEN f.required = \'t\' THEN \'true\' ELSE \'false\' END as required, f.class_id_fk, f.visible, i.value, i.field_id_fk, i.pdf_user_id_fk FROM pdf_field f LEFT JOIN pdf_input i ON (i.field_id_fk = f.id AND...- wwtf
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
