copy table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I created a new database and I want to copy a table from a different database into the new database.

1. I used phpPgAdmin and exported the table that I want a copy of.

2. In the new database I pasted the export into the SQL box in phpPgAdmin and clicked execute to create the table.

The table was created with no errors

The only problem is it did not create the sequence for the primary key.

 

Do I have to manually create the sequence or did I miss a step in exporting and creating the table?

 

 

Thanks

 

Marc

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux