e-letter wrote on 24.04.2011 22:52:
> Is it possible to use the result of a SELECT function to populate a
> new table? The objective is to write the new table for use by gnuplot.
> The SELECT function features a mathematical operator such as SUM which
> obtains a value. Is it possible to use the value from this function to
> be entered into the new table. Please advise the relevant parts of the
> documentation to read.
CREATE TABLE new_table
SELECT col1, col2, col3
This is the syntax I always use, but I have just realized that it not documented in the manual...
Or using SELECT INTO:
SELECTcol1, col2, col3
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2011-04-24 21:19:10|
|Subject: Re: insert retrieved data into a new table |
|Previous:||From: e-letter||Date: 2011-04-24 20:52:32|
|Subject: insert retrieved data into a new table|