[GENERAL] Which file belongs to which database?

Hello all, just out of curiosity: how can I find out which files in the PG_DATA directory belong to which database/table? I have looked through the documentation of the system catalogs, but couldn't find any reference to that. The field datpath in pg_database is empty in my system (7.2 on Wind

Re: [GENERAL] Which file belongs to which database?

Shridhar Daithankar schrieb: On 25 Jul 2003 at 8:45, Thomas Kellerer wrote: just out of curiosity: how can I find out which files in the PG_DATA directory belong to which database/table? There is a contrib module oid2name. Use that. You can just find the oid of the object from catalog and

Re: [GENERAL] list triggers - how?

Holger Marzen schrieb: How can I list defined triggers on PostgreSQL 7.1.3? I'm using the following statement: select trg.tgname, tbl.relname, case trg.tgtype & cast(2 as int2) when 0 then 'AFTER' else 'BEFORE' end as trigger_type, case trg.tgtype & cast(28

Re: [GENERAL] Output from PLPGSQL

Richard Huxton schrieb: On Wednesday 03 September 2003 12:19, Amin Schoeib wrote: Hi, How can I make textoutput (for example for tracing the code) in PLPGSQL. In Oracle you can do that using dbms.output.put_line RAISE NOTICE ''My counter is % with total %'',i,run_tot; Double-quoted string as u

<    4   5   6   7   8   9