Dropping sub-tables - Mailing list pgsql-novice

From Gan Uesli Starling
Subject Dropping sub-tables
Date
Msg-id 43E13D4E.6090409@starling.us
Whole thread Raw
Responses Re: Dropping sub-tables
List pgsql-novice
Say I have a table for equipment having columns for ordinary
equipment. It also has sub-tables for things like sensors with
extra columns for specialty info.

I'd like to revert to having only the main table without any
sub-tables, but keep the rows from the sub-tables which are
common to the parent table.

If I drop the sub-tables, do I loose all if their rows, or
only the columns not shared with the parent table?

TIA,

pgsql-novice by date:

Previous
From: Dyanesh NagarajaRao
Date:
Subject: Postgres Installation problem.
Next
From: Chris Browne
Date:
Subject: Re: maximum for database users?