Re: CREATE OR REPLACE TABLE ...

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(at)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