Skip site navigation (1) Skip section navigation (2)

Dropping sub-tables

From: Gan Uesli Starling <gan(at)starling(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Dropping sub-tables
Date: 2006-02-01 22:59:26
Message-ID: 43E13D4E.6090409@starling.us (view raw or flat)
Thread:
Lists: 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,

Responses

pgsql-novice by date

Next:From: Gan Uesli StarlingDate: 2006-02-01 23:39:13
Subject: Reverting from subtables to no subtables.
Previous:From: Ketema HarrisDate: 2006-02-01 16:26:47
Subject: How To Return a Row or Result Set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group