Much More Scientific
77% SCIENTIFIC INTUITION and
47% EMOTIONAL INTUITION
Try my other test!
The 3 Variable Funny Test
|My test tracked 2 variables How you compared to other people your age and gender:|
|Link: The 2-Variable Intuition Test written by jason_bateman on Ok Cupid, home of the 32-Type Dating Test|
CREATE OR REPLACE VIEW table_attributes AS SELECT c.relname AS tablename, a.attname AS attrname, t.typname AS type, a.attnotnull AS required, d.description AS description FROM pg_class c JOIN pg_attribute a ON a.attrelid=c.oid JOIN pg_type t ON a.atttypid=t.oid LEFT OUTER JOIN pg_description d ON d.objoid=c.oid AND d.objsubid=a.attnum WHERE a.attnum>0 AND a.attisdropped = 'f' AND c.relkind='r' AND c.relname NOT LIKE 'pg_%' AND c.relname NOT LIKE 'sql_%' ORDER BY tablename, a.attnum;Nice, but still not enough - As with any other RDBMS, fields can not only hold data, but -of course- they can be foreign keys, referring to data in other tables. Ok, in order to check those relations and be able to build a map of the relations in my DB, I came up with this:
CREATE OR REPLACE VIEW related_tables AS SELECT c1.relname AS referrer, c2.relname AS refered, a.attname AS ref_key FROM pg_constraint con JOIN pg_class c1 ON con.conrelid=c1.oid JOIN pg_class c2 ON con.confrelid=c2.oid JOIN pg_attribute a ON c1.oid=a.attrelid AND a.attnum=ANY(con.conkey) WHERE contype='f' ORDER BY c1.relname, c2.relname;In the first query, note that I am excluding from what I report all the tables starting with pg_ or sql_ - While that's a usual convention in Postgres, there surely is a better way to do it, some attribute signalling it's a system catalog... But, at least for now, this covers my needs. Anyway, this might come useful for your projects. PostgreSQL introspection is fun! (Yes, those two queries are the result of many lonely hours going through the documentation and a couple of spontaneous questions to several friends - But it's worth it!)
- Gunnar needs to stamp images with time when captured
- Obviously gunnar needs a world map store and use the information he has gathered
- Gunnar needs a box for his blocks
- Gunnar needs to finish his clean-ups he planned or I guess already started.
- Gunnar needs to develop more body rhythm to advance in this style.
- Go rent "Scars Don't Sweat' because Gunnar needs the .003 cents he earns from each rental
- Asther and Gunnar need a miracle! Asther needs her healing and Gunnar needs an additional measure of God’s strength and grace as he cares for Asther
- Gunnar needs your help with Dwellingup data
I just strongly disagree with pure simplification being the right way in UI design.This is the problem with Galeon: That it went far away from its original intention. Its original motto (which I discovered to be still in use) is The web. only the web... Well, I really enjoyed pre-1.2 versions of Galeon, but it just bloated, bloated, bloated until it was no longer usable for me. I too hate many aspects of Firefox, only it is the most usable browser I have seen... I still have to look at Kazehakase, but from the little that I can get from its page, it is not what I want. I want, just as you, something light, not over-featured, but tunable to my personal preferences. And while Firefox's configuration is closer to the extra wheels for a bycicle you complain about in Galeon, I have been able to tune it quite a lot via extensions.