Thread: CREATE TABLE docs question
http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html Reading the docs, the following should work: CREATE TABLE messageblks like dbmail_messageblks; but it says: ERROR: syntax error at or near "like" ZEILE 1: CREATE TABLE messageblks like dbmail_messageblks; ^ What's my error? mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Attachment
Michael Monnerie написа: > http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html > > Reading the docs, the following should work: > > CREATE TABLE messageblks like dbmail_messageblks; > > but it says: > ERROR: syntax error at or near "like" > ZEILE 1: CREATE TABLE messageblks like dbmail_messageblks; > ^ > > What's my error? Should be "CREATE TABLE messageblks (like dbmail_messageblks);" -- Milen A. Radev
"Milen A. Radev" <milen@radev.net> schrieb: > Should be "CREATE TABLE messageblks (like dbmail_messageblks);" Thanks, works. Ah, and now I found the bracket in the docs. There are so many I overlooked it, maybe also because that command looks a bit strange (like patched); mfg zmi