Re: [GENERAL] fields and foreign keys

2005-06-24 Thread mrix
Yeah, thanks! But I've already tried this approach, and it's not quite i need. Because as i understand foreign keys are built on indexes, so i get *index* and corresponding foreign key definition. Well then i have to find out what filed this index "belongs to" (assuming 1 field - 1 index) ---

Re: [GENERAL] multi-languages in a table

2005-06-24 Thread mrix
This may cause troubles to, because sorting is done using LC_COLLATE value, whuch cannot be changed, and is set with initdb. So please consider this limitation before doing any changes. ---(end of broadcast)--- TIP 7: don't forget to increase your

[GENERAL] fields and foreign keys

2005-06-23 Thread mrix
Hello! I'd like to know how can i get list of fields and corresponding foreign keys (referenced table and field). Thanks! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org