Revolucent icon

PostgreSQL Tables Without PKs

Revolucent | PRO | 03/17/17 05:04:23 AM UTC | 0 ⭐ | 7877 👁️ | Never ⏰ | []
PostgreSQL |

450 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
WITH relpub AS (
  SELECT  r.oid
      ,   r.relname
  FROM    pg_class r
          INNER JOIN pg_namespace n ON r.relnamespace = n.oid AND r.relkind = 'r' AND n.nspname = 'public'
),
pk AS (
  SELECT  r.oid
  FROM    relpub r
          INNER JOIN pg_index i ON r.oid = i.indrelid AND i.indisprimary
)
SELECT  r.relname
FROM    relpub r
WHERE   NOT EXISTS (
          SELECT  oid
          FROM    pk
          WHERE   oid = r.oid
        );

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    •