[GENERAL] How to ;ist all table foreign key dependency relationships

2012-07-22 Thread Berend Tober
I am interested in listing all the pairwise foreign key dependencies between tables by name, i.e., if I have table A with some primary key column A.id, and table B has a foreign key referencing A.id, then table B depends on A. I found some things by Google searching, but most of these were not

Re: [GENERAL] Why is an ISO-8859-8 database allowing values not within that set?

2012-07-22 Thread Craig Ringer
On 07/22/2012 03:58 PM, Herouth Maoz wrote: Thanks. That makes sense. The default client encoding on the reports database is ISO-8859-8, so I guess when I don't set it using \encoding, it does exactly what you say. OK, so I'm still looking for a way to convert illegal characters into somethin

Re: [GENERAL] Why is an ISO-8859-8 database allowing values not within that set?

2012-07-22 Thread Herouth Maoz
Thanks. That makes sense. The default client encoding on the reports database is ISO-8859-8, so I guess when I don't set it using \encoding, it does exactly what you say. OK, so I'm still looking for a way to convert illegal characters into something that won't collide with my encoding (asteris