Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
PostgreSQL
(edit)
Revision as of 14:11, 13 February 2016
236 bytes added
,
14:11, 13 February 2016
no edit summary
Line 28:
Line 28:
From the postgres user shell:
From the postgres user shell:
createdb test1
createdb test1
−
==
Create table
==
+
==
CREATE TABLE / DROP TABLE
==
+
<nowiki>
+
CREATE TABLE table_name (
+
column_name1 col_type (field_length) column_constraints,
+
column_name2 col_type (field_length),
+
column_name3 col_type (field_length)
+
);
+
+
DROP TABLE table_name</nowiki>
Rafahsolis
Bureaucrats
,
Administrators
2,306
edits
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Create account
Log in
Namespaces
Page
Discussion
Variants
Views
Read
Edit
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
Special pages
Printable version