Unix Technical Forum

CREATE TABLE synopsis

This is a discussion on CREATE TABLE synopsis within the pgsql Hackers forums, part of the PostgreSQL category; --> The CREATE TABLE synopsis shows this: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 05:12 AM
Alvaro Herrera
 
Posts: n/a
Default CREATE TABLE synopsis

The CREATE TABLE synopsis shows this:

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
)

However, we now allow zero-column tables, so it should actually be

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
[ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
| LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ]
)

Right?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-11-2008, 05:13 AM
Bruce Momjian
 
Posts: n/a
Default Re: CREATE TABLE synopsis


Right, fixed in create_table.sgml. I don't think it is any other place.

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> The CREATE TABLE synopsis shows this:
>
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
> { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
> | table_constraint
> | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ]
> )
>
> However, we now allow zero-column tables, so it should actually be
>
> CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
> [ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
> | table_constraint
> | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ]
> )
>
> Right?
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:13 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com