Home > mailing lists

SELECT 'pg_catalog.pg_class'::regclass::oid - Mailing list pgsql-general

From	Tom Hebbron
Subject	SELECT 'pg_catalog.pg_class'::regclass::oid
Date	November 24, 2003 18:09:43
Msg-id	bpjbcq$v0j$1@news.hub.org Whole thread Raw
List	pgsql-general

Tree view

Hi list,

test=# SELECT 'pg_catalog.pg_class'::regclass::oid;
 oid
------
 1259
(1 row)

test=# SELECT '1259'::oid::regclass;
 regclass
----------
 pg_class
(1 row)

test=# SELECT '1259'::oid::regclass::text || '.relname';
ERROR:  cannot cast type regclass to text
test=#

Could the regclass psuedo-type give schema qualified output when given an
oid, and could it be castable to text please - it would make life easier?

pgsql-general by date:

From: semmelhaacknospam@gmx.de (tim)
Date: 24 November 2003, 18:08:24
Subject: Connecting Openoffice Postgres

From: "Markus Seibold"
Date: 24 November 2003, 18:09:53
Subject: Open source data modeling tools for PostgreSQL

SELECT 'pg_catalog.pg_class'::regclass::oid - Mailing list pgsql-general

Previous

Next