On 4 Oct 2003 at 12:22, Anshuman Kanwar wrote:
here's one way:
mfx=# begin; create table NEWTABLE as select * from OLDTABLE; delete from
NEWTABLE; end;
Hope this helps
Paul Butler
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org