Activerecord, postgres and views?

hi there

is it possible to use a postgres view in AR?

this code is being executed by AR to find a relation

SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc,
a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = ‘iptrack’::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

but it does not find my view “iptrack”.

i realise i may not be able to update my view without postgres rewrite
rules, but I think i should be able to do searches on a view

thanks for any help


sorry for the prior post, my mistake!

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs