Greg Stark <[EMAIL PROTECTED]> writes:
I just dropped a column that I wish I hadn't. Is there some simple update i could do to the pg_* tables that would undrop it?
You could rsync the database back from your live off-site backup, or rifle through the piles of backups to recover from last night's archive backup :)
Another alternative, if it's just the schema not the data you need back, is simply to "alter table add column ..." the column back. Note that if you want it to be "not null" or "default x" you have to add the column, update the table with the default value in each column, alter the column to be not null then alter the column to be default x.
Though this probably isn't what you were looking for, it's still on the archives for someone else to stumble across c/o Google
Alex
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
