{"id":2560,"date":"2026-08-11T10:21:52","date_gmt":"2026-08-11T08:21:52","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=2560"},"modified":"2026-08-11T10:28:36","modified_gmt":"2026-08-11T08:28:36","slug":"come-esportare-la-struttura-e-i-dati-di-una-tabella-postgres","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/come-esportare-la-struttura-e-i-dati-di-una-tabella-postgres\/","title":{"rendered":"Come esportare la struttura e i dati di una tabella Postgres"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"2560\" class=\"akihiro akihiro-2560\" data-akihiro-post-type=\"post\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-2507986 e-flex e-con-boxed e-con e-parent\" data-id=\"2507986\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-028e449 akihiro-widget akihiro-widget-text-editor\" data-id=\"028e449\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tSe hai la necessit\u00e0 di esportare una singola tabella PostgreSQL, <code>pg_dump<\/code> mette a disposizione diverse opzioni che consentono di salvare solamente la struttura della tabella, solamente i dati oppure entrambe.\n\nDi seguito vediamo i tre casi pi\u00f9 comuni.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8ad9c2d akihiro-widget akihiro-widget-heading\" data-id=\"8ad9c2d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Riepilogo dei comandi<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8c2d531 akihiro-widget akihiro-widget-text-editor\" data-id=\"8c2d531\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<table><thead><tr><th>Operazione<\/th><th>Comando<\/th><\/tr><\/thead><tbody><tr><td>Solo struttura<\/td><td><code>pg_dump --schema-only<\/code><\/td><\/tr><tr><td>Struttura + dati<\/td><td><code>pg_dump<\/code><\/td><\/tr><tr><td>Solo dati<\/td><td><code>pg_dump --data-only<\/code><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-610a75d akihiro-widget akihiro-widget-heading\" data-id=\"610a75d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Esportare solamente la struttura di una tabella<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4b3d5cd akihiro-widget akihiro-widget-text-editor\" data-id=\"4b3d5cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Se desideri esportare esclusivamente lo schema della tabella (CREATE TABLE, indici, vincoli, ecc.) senza includere i dati, utilizza l&#8217;opzione <code>--schema-only<\/code>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8bc4e99 akihiro-widget akihiro-widget-code-highlight\" data-id=\"8bc4e99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_dump -U username -d database -t nome_tabella --schema-only > struttura.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8e08ad4 akihiro-widget akihiro-widget-text-editor\" data-id=\"8e08ad4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tIl file <code>struttura.sql<\/code> conterr\u00e0 solamente le istruzioni SQL necessarie per ricreare la tabella.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-9794589 akihiro-widget akihiro-widget-heading\" data-id=\"9794589\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Esportare struttura e dati<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-af16e05 akihiro-widget akihiro-widget-text-editor\" data-id=\"af16e05\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Per esportare sia la definizione della tabella che il suo contenuto \u00e8 sufficiente utilizzare pg_dump senza opzioni aggiuntive.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-6b0cdb1 akihiro-widget akihiro-widget-code-highlight\" data-id=\"6b0cdb1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_dump -U username -d database -t nome_tabella > completo.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7c5bd20 akihiro-widget akihiro-widget-text-editor\" data-id=\"7c5bd20\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il file generato potr\u00e0 essere utilizzato per ricreare completamente la tabella, compresi tutti i record presenti al momento dell&#8217;esportazione.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-60cfae3 akihiro-widget akihiro-widget-heading\" data-id=\"60cfae3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Esportare solamente i dati<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-0af2bd6 akihiro-widget akihiro-widget-text-editor\" data-id=\"0af2bd6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Nel caso in cui la struttura della tabella esista gi\u00e0 e sia necessario esportare esclusivamente i record, \u00e8 possibile utilizzare l&#8217;opzione <code>--data-only<\/code>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-304153e akihiro-widget akihiro-widget-code-highlight\" data-id=\"304153e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_dump -U username -d database -t nome_tabella --data-only > dati.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-0fd76ee akihiro-widget akihiro-widget-text-editor\" data-id=\"0fd76ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il file risultante conterr\u00e0 solamente le istruzioni <code data-start=\"2101\" data-end=\"2109\">INSERT<\/code>, senza alcun comando relativo alla creazione della tabella.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-9b2f2b0 akihiro-widget akihiro-widget-heading\" data-id=\"9b2f2b0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Esportare una tabella appartenente a uno schema<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-85920eb akihiro-widget akihiro-widget-text-editor\" data-id=\"85920eb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Se la tabella da esportare appartiene a uno schema diverso da quello predefinito, \u00e8 possibile specificare il nome dello schema direttamente tramite l&#8217;opzione <code>-t<\/code>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7524d65 akihiro-widget akihiro-widget-code-highlight\" data-id=\"7524d65\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_dump -U username -d database -t schema.nome_tabella > completo.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4e5175e akihiro-widget akihiro-widget-text-editor\" data-id=\"4e5175e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ad esempio, per esportare la tabella <code>ordini<\/code> appartenente allo schema <code>vendite<\/code>:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-c8c835f akihiro-widget akihiro-widget-code-highlight\" data-id=\"c8c835f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_dump -U username -d database -t vendite.ordini > completo.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-32244b9 akihiro-widget akihiro-widget-text-editor\" data-id=\"32244b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In questo modo <code>pg_dump<\/code> esporter\u00e0 esclusivamente la tabella indicata all&#8217;interno dello schema specificato.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-fd1b14b akihiro-widget akihiro-widget-heading\" data-id=\"fd1b14b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Importare il dump<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7f7bb55 akihiro-widget akihiro-widget-text-editor\" data-id=\"7f7bb55\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Per ripristinare uno dei file generati \u00e8 sufficiente utilizzare <code data-start=\"2681\" data-end=\"2687\">psql<\/code>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-f985e9f akihiro-widget akihiro-widget-code-highlight\" data-id=\"f985e9f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>psql -U username -d database < struttura.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-e2c7e2f akihiro-widget akihiro-widget-code-highlight\" data-id=\"e2c7e2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>psql -U username -d database < completo.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-681486d akihiro-widget akihiro-widget-code-highlight\" data-id=\"681486d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>psql -U username -d database < dati.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4ef5f67 akihiro-widget akihiro-widget-heading\" data-id=\"4ef5f67\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h2 class=\"akihiro-heading-title akihiro-size-default\">Conclusione<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-051a183 akihiro-widget akihiro-widget-text-editor\" data-id=\"051a183\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tCon <code>pg_dump<\/code> \u00e8 possibile esportare rapidamente una singola tabella PostgreSQL scegliendo se includere solamente la struttura, solamente i dati oppure entrambe. \u00c8 una funzionalit\u00e0 particolarmente utile per migrare tabelle tra database, creare backup mirati o condividere dati senza esportare l&#8217;intero database.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"akihiro-element akihiro-element-7f0740a e-flex e-con-boxed e-con e-parent\" data-id=\"7f0740a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Se hai la necessit\u00e0 di esportare una singola tabella PostgreSQL, pg_dump mette a disposizione diverse opzioni che consentono di salvare solamente la struttura della tabella, solamente i dati oppure entrambe. Di seguito vediamo i tre casi pi\u00f9 comuni. Riepilogo dei comandi Operazione Comando Solo struttura pg_dump &#8211;schema-only Struttura + dati pg_dump Solo dati pg_dump &#8211;data-only [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[50,16],"class_list":["post-2560","post","type-post","status-publish","format-standard","hentry","category-sistemistica","tag-postgresql","tag-sql"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=2560"}],"version-history":[{"count":13,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2560\/revisions"}],"predecessor-version":[{"id":2575,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2560\/revisions\/2575"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=2560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=2560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=2560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}