Postgres Pro
Downloads
Home   >   mailing lists

creating a new table with data from other tables - Mailing list pgsql-sql

From Willian Jakobs
Subject creating a new table with data from other tables
Date
Msg-id 7hp128$a7p$1@info.service.rug.nl
Whole thread Raw
List pgsql-sql
Tree view 
I have to create a table with data from other tables.
I dont how many tables, the tablesnames are:
student<00>, where 00 is a number. So I cant specify the table name.
The tables dont have primary keys.
And I only have to insert two fields into the new table.
All this is for a database in ms-access and I want to try to solve this
problem with SQL.
Please help me and i will thank u.

Willian Jakobs

pgsql-sql by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Create Rule problems
Next
From: secret
Date:
Subject: Re: [SQL] Oddities with NULL and GROUP BY