CREATE OR REPLACE TABLE ...

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: CREATE OR REPLACE TABLE ...
Date: 2003-02-26 12:37:37
Message-ID: 200302261807.37219.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-02-26 15:50:25 Re: ExclusiveLock and Python
Previous Message Daniel Rubio 2003-02-26 11:49:33 Limiting database size ...