{"id":18220,"date":"2021-01-07T07:41:22","date_gmt":"2021-01-07T07:41:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=18220"},"modified":"2021-01-07T07:41:22","modified_gmt":"2021-01-07T07:41:22","slug":"postgresql-copy-command-example","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/","title":{"rendered":"PostgreSQL copy command Example"},"content":{"rendered":"<p>This article contains information about PostgreSQL copy command example such as exporting query result to csv, importing file to postgres.<\/p>\n<h3>What is PostgreSQL copy command?<\/h3>\n<ul>\n<li>The COPY command moves data between PostgreSQL tables and standard file system files.<\/li>\n<li>COPY TO copies the contents of the table to the file.<\/li>\n<li>COPY TO can also copy the results of the SELECT query. That is, if the column list is specified, COPY TO only copies the data in the specified columns to the file.<\/li>\n<li>The COPY command instructs the PostgreSQL server to read from or write to the file directly. Therefore, the file must be accessible to the PostgreSQL user.<\/li>\n<li>COPY FROM copies the data from the file to the table.<\/li>\n<li>When using the COPY FROM command, each field in the file is inserted sequentially to the specified column. Table columns not specified in the COPY FROM column list get their default values.<\/li>\n<li>It is necessary to grant SELECT privilege on the table read by COPY TO, and the INSERT privilege in the table where the values are inserted with COPY FROM.<\/li>\n<li>COPY TO can only be used with tables, not views. However, if we want to copy the contents of the view, we must feed the COPY command with the sql query.<\/li>\n<\/ul>\n<blockquote>\n<pre class=\"lang:default decode:true\" style=\"padding-left: 160px;\">( COPY (SELECT * FROM country) TO \u2018list_countries.copy\u2019;).<\/pre>\n<\/blockquote>\n<ul>\n<li>Files named in the COPY command are read or written directly by the server, not by the client application. Therefore, it must be located on or accessible to the database server machine, not the client either.<\/li>\n<li>We shouldn&#8217;t confuse COPY with \\copy in psql. \\copy calls COPY FROM STDIN or COPY TO STDOUT and then retrieves and stores the data from a file accessible by the psql client. Therefore, file accessibility and access rights depend on the client rather than the server when using \\copy.<\/li>\n<\/ul>\n<h3>PostgreSQL copy command Example<\/h3>\n<h4>Export table in PostgreSQL<\/h4>\n<p>We can copy the table to the client by using the vertical bar (|) as a delimiter between columns with the following command.<\/p>\n<pre class=\"lang:default decode:true \">COPY country TO STDOUT (DELIMITER '|');<\/pre>\n<p>We can copy the table to the file we want by using spaces as delimiter between columns with the following command.<\/p>\n<pre class=\"lang:default decode:true \">COPY country TO '\/database\/data\/test_data.copy' (DELIMITER ' ');\r\n<\/pre>\n<h4>Import file to PostgreSQL<\/h4>\n<p>We can transfer the data in the file to our existing table with the following command.<\/p>\n<pre class=\"lang:default decode:true\">COPY country FROM '\/database\/data\/test_data.copy' (DELIMITER ' ');<\/pre>\n<h4>Export query result to file in PostgreSQL<\/h4>\n<p>We can export the result of a query to a file.<\/p>\n<pre class=\"lang:default decode:true \">COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO '\/database\/data\/test_data.copy';\r\n<\/pre>\n<p>If we want to compress the output we will get with the program, we can use the following command.<\/p>\n<pre class=\"lang:default decode:true \">COPY country TO PROGRAM 'gzip &gt; \/database\/data\/test_data.copy.gz';\r\n<\/pre>\n<p>If we want to export only 2 columns, we can use the following command.<\/p>\n<pre class=\"lang:default decode:true \">COPY country(col, col2) TO '\/database\/data\/test_data.copy' DELIMITER ' ';\r\n<\/pre>\n<p>If we want to export in binary format, we can get it as follows.<\/p>\n<pre class=\"lang:default decode:true \">COPY country TO STDOUT WITH BINARY;<\/pre>\n<p>If we want to export in CSV format, we can get it as follows. If you want you can<strong> export query result to csv in postgres<\/strong> in this way.<\/p>\n<pre class=\"lang:default decode:true\">COPY country TO STDOUT WITH CSV;<\/pre>\n<p>There are a few basic terms we need to know about CSV files;<\/p>\n<p><strong>DELIMITER<\/strong> &#8211; Delimiter is a character that separates each row of the file into columns; In the CSV file, the delimiter is comma.<\/p>\n<p><strong>HEADER<\/strong> &#8211; When a CSV file is created, the header row is the first line of the file containing the column names. If you don&#8217;t want column names to be copied to the CSV file, you can ignore HEADER.<\/p>\n<pre class=\"lang:default decode:true \">COPY  country FROM  '\/database\/data\/test_data.copy' WITH delimiter ','  CSV HEADER;\r\n<\/pre>\n<p>For example, if you have Turkish characters, you can use encoding as follows.<\/p>\n<pre class=\"lang:default decode:true \">COPY country  FROM  '\/database\/data\/test_data.copy' WITH delimiter ','  CSV HEADER encoding 'WIN1254';<\/pre>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18220\" class=\"pvc_stats all  \" data-element-id=\"18220\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article contains information about PostgreSQL copy command example such as exporting query result to csv, importing file to postgres. What is PostgreSQL copy command? The COPY command moves data between PostgreSQL tables and standard file system files. COPY TO copies the contents of the table to the file. COPY TO can also copy the &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_18220\" class=\"pvc_stats all  \" data-element-id=\"18220\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":926,"featured_media":18222,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[10335,10333,10338,10336,10337,10334],"class_list":["post-18220","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-copy-command-example-in-postgres","tag-export-query-result-to-csv-postgres","tag-export-query-result-to-file-in-postgresql","tag-export-table-in-postgres","tag-import-file-to-postgresql","tag-postgresql-copy-command"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL copy command Example - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL copy command Example - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-07T07:41:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"733\" \/>\n\t<meta property=\"og:image:height\" content=\"323\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mustafa Bekta\u015f Tepe\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mustafa Bekta\u015f Tepe\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\"},\"author\":{\"name\":\"Mustafa Bekta\u015f Tepe\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608\"},\"headline\":\"PostgreSQL copy command Example\",\"datePublished\":\"2021-01-07T07:41:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\"},\"wordCount\":552,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg\",\"keywords\":[\"copy command example in postgres\",\"export query result to csv postgres\",\"Export query result to file in PostgreSQL\",\"Export table in postgres\",\"Import file to PostgreSQL\",\"Postgresql copy command\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\",\"name\":\"PostgreSQL copy command Example - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg\",\"datePublished\":\"2021-01-07T07:41:22+00:00\",\"description\":\"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg\",\"width\":733,\"height\":323},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL copy command Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608\",\"name\":\"Mustafa Bekta\u015f Tepe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g\",\"caption\":\"Mustafa Bekta\u015f Tepe\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/mustafabektas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL copy command Example - Database Tutorials","description":"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL copy command Example - Database Tutorials","og_description":"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.","og_url":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/","og_site_name":"Database Tutorials","article_published_time":"2021-01-07T07:41:22+00:00","og_image":[{"width":733,"height":323,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg","type":"image\/jpeg"}],"author":"Mustafa Bekta\u015f Tepe","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mustafa Bekta\u015f Tepe","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/"},"author":{"name":"Mustafa Bekta\u015f Tepe","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608"},"headline":"PostgreSQL copy command Example","datePublished":"2021-01-07T07:41:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/"},"wordCount":552,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg","keywords":["copy command example in postgres","export query result to csv postgres","Export query result to file in PostgreSQL","Export table in postgres","Import file to PostgreSQL","Postgresql copy command"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/","url":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/","name":"PostgreSQL copy command Example - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg","datePublished":"2021-01-07T07:41:22+00:00","description":"This article contains information about PostgreSQL copy command and example such as exporting query result to csv, importing file to postgres.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/01\/copycommand.jpg","width":733,"height":323},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2021\/01\/07\/postgresql-copy-command-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL copy command Example"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bf61379dc4b6cb1df9a84293fc5da608","name":"Mustafa Bekta\u015f Tepe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce2391ff3d363a1456f398312ea70eb44d6ef7740742d9cfede93c491d3e7500?s=96&d=mm&r=g","caption":"Mustafa Bekta\u015f Tepe"},"url":"https:\/\/dbtut.com\/index.php\/author\/mustafabektas\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/926"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=18220"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/18220\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/18222"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=18220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=18220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=18220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}