CREATE OR REPLACE TABLE ...
От | Rajesh Kumar Mallah |
---|---|
Тема | CREATE OR REPLACE TABLE ... |
Дата | |
Msg-id | 200302261807.37219.mallah@trade-india.com обсуждение исходный текст |
Ответы |
Re: CREATE OR REPLACE TABLE ...
|
Список | 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 по дате отправления: