Обсуждение: CREATE OR REPLACE TABLE ...

Поиск
Список
Период
Сортировка

CREATE OR REPLACE TABLE ...

От
Rajesh Kumar Mallah
Дата:
Has create or replace table been implemented in 7.3 ?
or am i doing somthing silly?


regds
mallah.


[rmallah@system11 rmallah]$ psql
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

Border style is 2.
Timing is on.
tradein_clients=# SELECT version();
+-----------------------------------------------------------+
|                          version                          |
+-----------------------------------------------------------+
| PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 |
+-----------------------------------------------------------+
(1 row)

Time: 0.92 ms
tradein_clients=# CREATE table t_test (a int );
CREATE TABLE
Time: 17.50 ms
tradein_clients=# CREATE or REPLACE table t_test (a int );
ERROR:  parser: parse error at or near "table" at character 19
tradein_clients=#




Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

Re: CREATE OR REPLACE TABLE ...

От
Robert Treat
Дата:
It is not implemented.

Robert Treat

On Wed, 2003-02-26 at 07:37, Rajesh Kumar Mallah wrote:
>
> Has create or replace table been implemented in 7.3 ?
> or am i doing somthing silly?
>
>
> regds
> mallah.
>
>
> [rmallah@system11 rmallah]$ psql
> Welcome to psql 7.3, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> Border style is 2.
> Timing is on.
> tradein_clients=# SELECT version();
> +-----------------------------------------------------------+
> |                          version                          |
> +-----------------------------------------------------------+
> | PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96 |
> +-----------------------------------------------------------+
> (1 row)
>
> Time: 0.92 ms
> tradein_clients=# CREATE table t_test (a int );
> CREATE TABLE
> Time: 17.50 ms
> tradein_clients=# CREATE or REPLACE table t_test (a int );
> ERROR:  parser: parse error at or near "table" at character 19
> tradein_clients=#
>
>
>
>
> Regds
> Mallah
>
> ----------------------------------------
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html