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

From Rajesh Kumar Mallah
Subject CREATE OR REPLACE TABLE ...
Date
Msg-id 200302261807.37219.mallah@trade-india.com
Whole thread Raw
Responses Re: CREATE OR REPLACE TABLE ...
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Daniel Rubio
Date:
Subject: Limiting database size ...
Next
From: Tom Lane
Date:
Subject: Re: ExclusiveLock and Python