Difference between revisions of ".sql"
Jump to navigation
Jump to search
(Created page with " -- Create extensions CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- -- Create Users -- -- Passwords should be random generated with 40 alphanumeric chars fo...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
-- Create extensions | -- Create extensions | ||
[[CREATE EXTENSION IF NOT EXISTS]] "[[uuid-ossp]]"; | [[CREATE EXTENSION IF NOT EXISTS]] "[[uuid-ossp]]"; | ||
| − | + | ||
-- | -- | ||
-- Create Users | -- Create Users | ||
| Line 10: | Line 10: | ||
-- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults. | -- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults. | ||
[[CREATE USER]] xxxx WITH PASSWORD 'xxxxxx'; | [[CREATE USER]] xxxx WITH PASSWORD 'xxxxxx'; | ||
| − | + | ||
| − | + | ||
-- | -- | ||
-- Create Database and Schema | -- Create Database and Schema | ||
| Line 18: | Line 18: | ||
\c XXXXX | \c XXXXX | ||
[[CREATE SCHEMA]] yyyyy; | [[CREATE SCHEMA]] yyyyy; | ||
| + | |||
| + | == See also == | ||
| + | * {{SQL}} | ||
| + | |||
| + | [[Category:SQL]] | ||
Latest revision as of 14:49, 20 September 2024
-- Create extensions CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- -- Create Users -- -- Passwords should be random generated with 40 alphanumeric chars for each environment and stored in the correct vaults. CREATE USER xxxx WITH PASSWORD 'xxxxxx'; -- -- Create Database and Schema -- \c XXXXX CREATE SCHEMA yyyyy;
See also[edit]
- SQL, NewSQL, RDMS: GraphQL (2015), SQLite,
select, insert,select count, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables,EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint,.sql
Advertising:
