insert into table from query in Postgresql

Question

I have a table Ty contains:

  a integer NOT NULL,
  b text,
  c text,
  d text,
  e text

I'm trying to do insrert statment as follows:

insert into Ty (b,c,d,e) values
                ('hello','world',select current_date,select name from users where userid=4)

But it doesn't work. It says:

ERROR: syntax error at or near "select"

All guides I read says that I can do SQL statement in Insert as long as they return just one value. So why it doesn't work?

Madhivanan · Accepted Answer · 2015-07-15 13:08:49Z

2

insert into Ty (b,c,d,e) 
select 'hello','world',current_date,name from users 
where userid=4

answered Jul 15, 2015 at 12:47

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

The keyword values causes same error. @Paul answer works

I noticed extrac brace and already removed it. See my edited reply

Still won't work; the values keyword shouldn't be there

Paul Grimshaw · Accepted Answer · 2015-07-15 12:47:30Z

1

insert into Ty (b,c,d,e)
SELECT 'hello','world',current_date, name from users where userid=4

answered Jul 15, 2015 at 12:47

Paul Grimshaw

21.2k6 gold badges43 silver badges60 bronze badges

Hans-Jürgen Schönig · Accepted Answer · 2015-07-15 13:28:27Z

0

a second way to do it is to add ( ) around the SELECT as shown in the next example:

test=# SELECT (SELECT 1);
 ?column? 
----------
        1
(1 row)

answered Jul 15, 2015 at 13:28

7616 silver badges4 bronze badges