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...") |
|||
| 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; | ||
| + | |||
| + | {{SQL}} | ||
Revision as of 08:07, 18 July 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;
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:
