Create new table from another table values
Create new table from another table values
(OP)
Hi,
How can I select all or part of the data from a table, create a new table and insert all the selected data in it.
My query would look like Select * from table but how can I create a new table and insert those data in it.
Thanks for your help
How can I select all or part of the data from a table, create a new table and insert all the selected data in it.
My query would look like Select * from table but how can I create a new table and insert those data in it.
Thanks for your help
RE: Create new table from another table values
To answer the question, you can use the SELECT INTO syntax. For example:
CODE
The same statement can be made into a VIEW and reused easier:
CODE
and then used with:
CODE
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Create new table from another table values
Since I am having problems converting with Access, the purpose is to create a new table with only part of the table. I can then use this new table, or give it to my helper to create some crystal report when I am too busy.
I just do not want them to connect directly to the master database.
RE: Create new table from another table values
The syntax I posted will work in v11 however it will only create a new PSQL table. It won't create an Access table.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Create new table from another table values