"George Pavlov" <gpavlov@xxxxxxxxxxxxxx> writes: > Looking at the information_schema.columns view I have been wondering why > it only shows the column_default for columns in tables owned by the > current user? Because that's what the SQL99 spec says it should do. The SQL2003 spec seems to have a looser definition, but we haven't gotten around to trying to make information_schema follow SQL2003 instead of SQL99 ... regards, tom lane
