Re: CREATE OR REPLACE TABLE ... - Mailing list pgsql-admin

From Robert Treat
Subject Re: CREATE OR REPLACE TABLE ...
Date
Msg-id 1046283935.1014.502.camel@camel
Whole thread Raw
In response to CREATE OR REPLACE TABLE ...  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Limiting database size ...
Next
From: "Sidar Lopez Cruz"
Date:
Subject: Dump from mssql