PostgreSQL 教程

2分钟

PostgreSQL 命令-COPY

在表和文件之间拷贝数据。

COPY table_name [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE NOT NULL column [, ...] ]
COPY table_name [ ( column [, ...] ) ]
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ NULL [ AS ] 'null string' ]
[ CSV [ QUOTE [ AS ] 'quote' ]
[ ESCAPE [ AS ] 'escape' ]
[ FORCE QUOTE column [, ...] ]

上一节: PostgreSQL 命令-COMMIT 下一节: PostgreSQL 命令-CREATE AGGREGATE

直播支持申请

职业发展学习路径

热门技术学习路径

搜索热词

目录

评价

推荐

1. PostgreSQL 教程

PostgreSQL 介绍

什么是数据库？

ORDBMS 术语

PostgreSQL 特征

PostgreSQL 语法’

SQL 语句

PostgreSQL 命令-ABORT

PostgreSQL 命令-ALTER AGGREGATE

PostgreSQL 命令-ALTER COLLATION

PostgreSQL 命令-ALTER CONVERSION

PostgreSQL 命令-ALTER DATABASE

PostgreSQL 命令-ALTER DEFAULT PRIVILEGES

PostgreSQL 命令-ALTER DOMAIN

PostgreSQL 命令-ALTER FUNCTION

PostgreSQL 命令-ALTER GROUP

PostgreSQL 命令-ALTER INDEX

PostgreSQL 命令-ALTER LANGUAGE

PostgreSQL 命令-ALTER OPERATOR

PostgreSQL 命令-ALTER OPERATOR CLASS

PostgreSQL 命令-ALTER SCHEMA

PostgreSQL 命令-ALTER SEQUENCE

PostgreSQL 命令-ALTER TABLE

PostgreSQL 命令-ALTER TABLESPACE

PostgreSQL 命令-ALTER TRIGGER

PostgreSQL 命令-ALTER TYPE

PostgreSQL 命令-ALTER USER

PostgreSQL 命令-ANALYZE

PostgreSQL 命令-BEGIN

PostgreSQL 命令-CHECKPOINT

PostgreSQL 命令-CLOSE

PostgreSQL 命令-CLUSTER

PostgreSQL 命令-COMMENT

PostgreSQL 命令-COMMIT

PostgreSQL 命令-COPY

PostgreSQL 命令-CREATE AGGREGATE

PostgreSQL 命令-CREATE CAST

PostgreSQL 命令-CREATE CONSTRAINT TRIGGER

PostgreSQL 命令-CREATE CONVERSION

PostgreSQL 命令-CREATE DATABASE

PostgreSQL 命令-CREATE DOMAIN

PostgreSQL 命令-CREATE FUNCTION

PostgreSQL 命令-CREATE GROUP

PostgreSQL 命令-CREATE INDEX

PostgreSQL 命令-CREATE LANGUAGE

PostgreSQL 命令-CREATE OPERATOR

PostgreSQL 命令-CREATE OPERATOR CLASS

PostgreSQL 命令-CREATE ROLE

PostgreSQL 命令-CREATE RULE

PostgreSQL 命令-CREATE SCHEMA

PostgreSQL 命令-CREATE SERVER

PostgreSQL 命令-CREATE SEQUENCE

PostgreSQL 命令-CREATE TABLE

PostgreSQL 命令-CREATE TABLE AS

PostgreSQL 命令-CREATE TABLESPACE

PostgreSQL 命令-CREATE TRIGGER

PostgreSQL 命令-CREATE TYPE

PostgreSQL 命令-CREATE USER

PostgreSQL 命令-CREATE VIEW

PostgreSQL 命令-DEALLOCATE

PostgreSQL 命令-DECLARE

PostgreSQL 命令-DELETE

PostgreSQL 命令-DROP AGGREGATE

PostgreSQL 命令-DROP CAST

PostgreSQL 命令-DROP CONVERSION

PostgreSQL 命令-DROP DATABASE

PostgreSQL 命令-DROP DOMAIN

PostgreSQL 命令-DROP FUNCTION

PostgreSQL 命令-DROP GROUP

PostgreSQL 命令-DROP INDEX

PostgreSQL 命令-DROP LANGUAGE

PostgreSQL 命令-DROP OPERATOR

PostgreSQL 命令-DROP OPERATOR CLASS