| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | alex(at)neteconomist(dot)com |
| Cc: | James Thompson <jamest(at)ajrs(dot)com>, PgSQL General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Python Driver |
| Date: | 2005-02-11 21:39:20 |
| Message-ID: | 20050211213920.GA34714@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 11, 2005 at 04:26:04PM -0500, Alex Turner wrote:
>
> What does the column 'relation' in pg_locks key to (Is there any docs
> on the website for this?)
See the "System Catalogs" chapter in the documentation (substitute
your version of PostgreSQL in the link):
http://www.postgresql.org/docs/8.0/static/catalogs.html
"relation" refers to an oid in pg_class. An easy way to convert
it to a relation name is to cast it to regclass:
SELECT relation::regclass, * FROM pg_locks;
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven Willenberger | 2005-02-11 21:41:55 | Re: databases/p5-postgresql-plperl links to wrong libperl.so |
| Previous Message | Michael Fuhr | 2005-02-11 21:32:00 | Re: Python Driver |