'database/postgres_ppas'에 해당되는 글 16건

  1. 2016.04.27 PostgreSQL 시작 - 데이터베이스 생성 삭제 사용(psql 접속)

반응형


PostgreSQL

데이터베이스 생성

[postgres@localhost]$ /usr/local/pgsql/bin/createdb mydb


데이터베이스 삭제

[postgres@localhost]$ /usr/local/pgsql/bin/dropdb mydb


데이터베이스 사용하기

[postgres@localhost]$ /usr/local/pgsql/bin/psql mydb


[postgres@localhost]$ /usr/local/pgsql/bin/psql mydb

 

mydb=# SELECT version();     version정보확인

 

mydb=# \h           psql내장명령어목록확인(도움말)

 

Available help:
  ABORT                            ALTER TYPE                       CREATE SCHEMA                    DROP LANGUAGE                    MOVE
  ALTER AGGREGATE                  ALTER USER                       CREATE SEQUENCE                  DROP MATERIALIZED VIEW           NOTIFY
  ALTER COLLATION                  ALTER USER MAPPING               CREATE SERVER                    DROP OPERATOR                    PREPARE
  ALTER CONVERSION                 ALTER VIEW                       CREATE TABLE                     DROP OPERATOR CLASS              PREPARE TRANSACTION
  ALTER DATABASE                   ANALYZE                          CREATE TABLE AS                  DROP OPERATOR FAMILY             REASSIGN OWNED
  ALTER DEFAULT PRIVILEGES         BEGIN                            CREATE TABLESPACE                DROP OWNED                       REFRESH MATERIALIZED VIEW
  ALTER DOMAIN                     CHECKPOINT                       CREATE TEXT SEARCH CONFIGURATION DROP POLICY                      REINDEX
  ALTER EVENT TRIGGER              CLOSE                            CREATE TEXT SEARCH DICTIONARY    DROP ROLE                        RELEASE SAVEPOINT
  ALTER EXTENSION                  CLUSTER                          CREATE TEXT SEARCH PARSER        DROP RULE                        RESET
  ALTER FOREIGN DATA WRAPPER       COMMENT                          CREATE TEXT SEARCH TEMPLATE      DROP SCHEMA                      REVOKE
  ALTER FOREIGN TABLE              COMMIT                           CREATE TRANSFORM                 DROP SEQUENCE                    ROLLBACK
  ALTER FUNCTION                   COMMIT PREPARED                  CREATE TRIGGER                   DROP SERVER                      ROLLBACK PREPARED
  ALTER GROUP                      COPY                             CREATE TYPE                      DROP TABLE                       ROLLBACK TO SAVEPOINT
  ALTER INDEX                      CREATE AGGREGATE                 CREATE USER                      DROP TABLESPACE                  SAVEPOINT
  ALTER LANGUAGE                   CREATE CAST                      CREATE USER MAPPING              DROP TEXT SEARCH CONFIGURATION   SECURITY LABEL
  ALTER LARGE OBJECT               CREATE COLLATION                 CREATE VIEW                      DROP TEXT SEARCH DICTIONARY      SELECT
  ALTER MATERIALIZED VIEW          CREATE CONVERSION                DEALLOCATE                       DROP TEXT SEARCH PARSER          SELECT INTO
  ALTER OPERATOR                   CREATE DATABASE                  DECLARE                          DROP TEXT SEARCH TEMPLATE        SET
  ALTER OPERATOR CLASS             CREATE DOMAIN                    DELETE                           DROP TRANSFORM                   SET CONSTRAINTS
  ALTER OPERATOR FAMILY            CREATE EVENT TRIGGER             DISCARD                          DROP TRIGGER                     SET ROLE
  ALTER POLICY                     CREATE EXTENSION                 DO                               DROP TYPE                        SET SESSION AUTHORIZATION
  ALTER ROLE                       CREATE FOREIGN DATA WRAPPER      DROP AGGREGATE                   DROP USER                        SET TRANSACTION
  ALTER RULE                       CREATE FOREIGN TABLE             DROP CAST                        DROP USER MAPPING                SHOW
  ALTER SCHEMA                     CREATE FUNCTION                  DROP COLLATION                   DROP VIEW                        START TRANSACTION
  ALTER SEQUENCE                   CREATE GROUP                     DROP CONVERSION                  END                              TABLE
  ALTER SERVER                     CREATE INDEX                     DROP DATABASE                    EXECUTE                          TRUNCATE
  ALTER SYSTEM                     CREATE LANGUAGE                  DROP DOMAIN                      EXPLAIN                          UNLISTEN
  ALTER TABLE                      CREATE MATERIALIZED VIEW         DROP EVENT TRIGGER               FETCH                            UPDATE
  ALTER TABLESPACE                 CREATE OPERATOR                  DROP EXTENSION                   GRANT                            VACUUM
  ALTER TEXT SEARCH CONFIGURATION  CREATE OPERATOR CLASS            DROP FOREIGN DATA WRAPPER        IMPORT FOREIGN SCHEMA            VALUES
  ALTER TEXT SEARCH DICTIONARY     CREATE OPERATOR FAMILY           DROP FOREIGN TABLE               INSERT                           WITH
  ALTER TEXT SEARCH PARSER         CREATE POLICY                    DROP FUNCTION                    LISTEN                          
  ALTER TEXT SEARCH TEMPLATE       CREATE ROLE                      DROP GROUP                       LOAD                            
  ALTER TRIGGER                    CREATE RULE                      DROP INDEX                       LOCK                            

 

 

mydb=# \q           psql프로그램종료 ( quit, exit 를 마구 입력해도 종료가 안됨 )

 

 

[postgres@localhost]$

 

 


 

반응형
Posted by 공간사랑
,