Error while creating table in postgres 8.1

Question

My query:

create table schema1.new_table (like schema2.some table);

gives an error.

Is this due to version 8.1?

Is it possible to use two different schemas while creating table?

And what exactly _is_ the error? Btw: 8.1 is old, unsupported, deprecated and no longer maintained. You should ***really*** upgrade to an up-to-date version (9.x) — , Jun 24 '15 at 07:41
I can't upgrade version because my Linux veraion is also older. — angel Peter, Jun 24 '15 at 08:00
PostgreSQL version is unrelated to your Linux version, you can always upgrade if you want. Version 8.1 is unsupported since November 2010 and has many serious problems that are not fixed. Do yourself a favor and upgrade to a recent version. — Frank Heikens, Jun 24 '15 at 08:03
Okay. I will try to upgrade version. But currently I need workaround for this query. — angel Peter, Jun 24 '15 at 08:45

score 0 · Answer 1 · answered Jun 24 '15 at 07:51

0

Simple typo (spot the underscore)?

create table schema1.new_table (like schema2.some_table);

And you probably want to do this including defaults.

answered Jun 24 '15 at 07:51

Patrick

Please note that both schema names are different. – angel Peter Jun 24 '15 at 08:15

1 Answers1