| From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Copying a column into a temp. table | 
| Date: | 2010-10-01 13:54:09 | 
| Message-ID: | AANLkTi=P2yaDCRfare_FXwt94wZYigPy6DAWVXZ5Gg9g@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
How do you copy a column from table please?
I'm trying with PostgreSQL 8.1.21/CentOS 5.5:
# psql -a -f clean-forum.sql
start transaction;
START TRANSACTION
create temp table old_topics (topic_id integer) on commit delete rows;
CREATE TABLE
create temp table old_posts (post_id integer) on commit delete rows;
CREATE TABLE
select topic_id from phpbb_topics where forum_id=5 and topic_poster=1
and age(to_timestamp(topic_time))>interval '14 days' into old_topics;
psql:clean-forum.sql:6: ERROR:  syntax error at or near "into" at character 124
psql:clean-forum.sql:6: LINE 1: ...
age(to_timestamp(topic_time))>interval '14 days' into old_t...
psql:clean-forum.sql:6:
              ^
commit
ROLLBACK
Of course "select ... into" doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
Thank you
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriele Bartolini | 2010-10-01 13:57:39 | Re: Copying a column into a temp. table | 
| Previous Message | Robert Gravsjö | 2010-10-01 13:52:22 | Re: Analyze tool? |