Re: sql question
От | Adam Lang |
---|---|
Тема | Re: sql question |
Дата | |
Msg-id | 006401c028b8$01cd5020$330a0a0a@Adam обсуждение исходный текст |
Ответ на | sql question ("chris markiewicz" <cmarkiew@commnav.com>) |
Список | pgsql-general |
yeah insert into newtable (column1, column2, etc.) select * from temptable; Or however you need it. Here are the specifics: http://www.postgresql.org/docs/postgres/sql-insert.htm Adam Lang Systems Engineer Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "chris markiewicz" <cmarkiew@commnav.com> > To: "Postgres (E-mail)" <pgsql-general@postgresql.org> > Sent: Wednesday, September 27, 2000 3:11 PM > Subject: [GENERAL] sql question > > > > hello > > > > i just learned that some of the constraint altering functionality is not > > completely implemented. as a workaround, i selected all of the data from > > that table into a temp table, dropped and recreated the table (with the > > correct constraints), and now i want to re-insert the data. can this be > > done with a single sql stmt? > > > > thanks > > chris >
В списке pgsql-general по дате отправления: