Need to create a temporary table employee by inserting values from already created table person which belongs to people database but getting error from keyword not found where expected Answer You’d then use CTAS (Create Table As Select), not an invalid INTO clause; it is used for different purposes. Based on comment you posted, there are several options you might
Tag: keyword
Columns with keywords as names in PostgreSQL
I have a couple of tables which have keywords as column names. I am not able to write a subquery using them. Even if I use non-existing column names, the query works. For example I have a few questions – when I use a non-existing column name in a subquery, it works. But if I use the same column name