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.
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 ... |