select * from pg_type where typnamespace = 646280 ;

select * from pg_proc where pronamespace = мой ид

select *
from pg_catalog.pg_class
where oid = 646280 
or relnamespace = 646280 
or reltype = 646280 
or relowner = 646280 
or relam = 646280 
or relfilenode = 646280 
or reltablespace = 646280 
or reltoastrelid = 646280 
or reltoastidxid = 646280 

select *
from pg_catalog.pg_type
where oid = 646280 
or typnamespace = 646280 
or typowner = 646280 
or typrelid = 646280 
or typelem = 646280 
or typbasetype = 646280 

promdb=# select typname,typnamespace,typowner,typtype,typcategory,typdelim,typalign,typstorage,typdefaultbin,typdefault
from pg_catalog.pg_type
where oid = 646280 
or typnamespace = 646280 
or typowner = 646280 
or typrelid = 646280 
or typelem = 646280 
or typbasetype = 646280 ;
  typname  | typnamespace | typowner | typtype | typcategory | typdelim | typalign | typstorage | typdefaultbin | typdefault
-----------+--------------+----------+---------+-------------+----------+----------+------------+---------------+------------
 b_shift  |       646280  |       10 | c       | C           | ,        | d        | x          |               |
 _b_shift |       646280  |       10 | b       | A           | ,        | d        | x          |               |
(2 rows)

SELECT * 
into  b_shift_bkp
from  b_shift

postgres=# select version();
                                    version
--------------------------------------------------------------------------------
 PostgreSQL 8.4.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.4.3, 32-bit
(1 row)