Copy table structure

From: Anshuman Kanwar <ansh(at)expertcity(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Copy table structure
Date: 2003-10-04 19:22:26
Message-ID: 571354A131635E42AE6C1F584F5F9B3A011EFC18@cabfranc.ad.corp.expertcity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

How do I copy only the table structure from one tabe to another.

Table A has some data but I just want to copy the number of columns and the
column names from this table and create a table B. What is the best way of
doing this ?

Thanks in advance,
-ansh

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Lange 2003-10-05 13:03:17 Re: perlsub
Previous Message Nabil Sayegh 2003-10-04 18:03:08 Re: perlsub