{"id":23906,"date":"2025-04-30T09:00:00","date_gmt":"2025-04-30T08:00:00","guid":{"rendered":"https:\/\/www.dbvis.com\/?p=23906"},"modified":"2025-04-18T13:37:27","modified_gmt":"2025-04-18T12:37:27","slug":"create-database-in-postgresql-a-complete-guide","status":"publish","type":"post","link":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/","title":{"rendered":"CREATE DATABASE in PostgreSQL: A Complete Guide"},"content":{"rendered":"\n<div class=\"wp-block-group has-black-background-color has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:40px;padding-bottom:20px\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-05153d0\" data-block-id=\"05153d0\"><style>.stk-05153d0 {max-width:672px !important;min-width:auto !important;margin-right:auto !important;margin-left:auto !important;}<\/style><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-05153d0-column alignwide\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-0ae88f8\" data-v=\"4\" data-block-id=\"0ae88f8\"><style>.stk-0ae88f8-container{max-width:600px !important;min-width:auto !important;margin-right:auto !important;margin-left:auto !important;}<\/style><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-0ae88f8-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-0ae88f8-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-68a9012 stk-subtitle\" data-block-id=\"68a9012\"><style>.stk-68a9012 .stk-block-text__text{font-size:14px !important;color:#7B7B7B !important;font-family:\"jetbrainsmono\", Sans-serif !important;}@media screen and (max-width:1199px){.stk-68a9012 .stk-block-text__text{font-size:14px !important;}}<\/style><p class=\"stk-block-text__text has-text-color\">intro<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-a8f1ca9\" data-block-id=\"a8f1ca9\"><style>.stk-a8f1ca9 .stk-block-text__text{font-size:16px !important;color:#ffffff !important;font-family:\"authenticsans\", Sans-serif !important;}@media screen and (max-width:1199px){.stk-a8f1ca9 .stk-block-text__text{font-size:16px !important;}}<\/style><p class=\"stk-block-text__text has-text-color has-white-color\">Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.<\/p><\/div>\n\n\n<section class=\"thetableTools thetableTools__wrapper\">\n    <div class=\"thetableTools thetableTools__container\">\n        <span class=\"thetableTools thetableTools__subhead\">Tools used in the tutorial<\/span>\n        <div class=\"thetableTools thetableTools__table\">\n            <div class=\"thetableTools thetableTools__divider\"><\/div>\n            <div class=\"thetableTools thetableTools__headers\">\n                <span class=\"thetableTools thetableTools__header thetableTools__header--name\">Tool<\/span>\n                <span class=\"thetableTools thetableTools__header thetableTools__header--description\">Description<\/span>\n                <span class=\"thetableTools thetableTools__header thetableTools__header--link\">Link<\/span>\n            <\/div>\n                                <div class=\"thetableTools thetableTools__divider\"><\/div>\n                    <div class=\"thetableTools thetableTools__tool\">\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--name\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--icon\"><img decoding=\"async\" width=\"40\" height=\"40\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding-42x42.png\" class=\"attachment-40x40 size-40x40\" alt=\"Dbvisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding-42x42.png 42w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/dbvis_logo_nopadding.png 50w\" sizes=\"(max-width: 40px) 100vw, 40px\" \/><\/span>\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--name\">DBVISUALIZER<\/span>\n                        <\/div>\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--description\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--description\">TOP RATED DATABASE MANAGEMENT TOOL AND SQL CLIENT<\/span>\n                        <\/div>\n                        <div class=\"thetableTools thetableTools__col thetableTools__col--link\">\n                            <span class=\"thetableTools thetableTools__content thetableTools__content--link\">\n                                <a href=\"\/download\/\" class=\"ctaBlock ctaBlock__ctaLink ctaBlock__ctaLink--internal\">DOWNLOAD<\/a>\n                            <\/span>\n                        <\/div>\n                    <\/div>                        <div class=\"thetableTools thetableTools__divider\"><\/div>\n        <\/div>\n    <\/div>\n<\/section>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f50\" data-block-id=\"67f911a1c2f50\"><style>.stk-67f911a1c2f50 {margin-top:40px !important;margin-bottom:0px !important;}.stk-67f911a1c2f50-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f50-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f51\" data-v=\"4\" data-block-id=\"67f911a1c2f51\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f51-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f51-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f91195873a7\" data-block-id=\"stk67f91195873a7\"><p class=\"stk-block-text__text\">Adding databases to a new database server is one of the most common tasks performed by DBAs or database users. While standard SQL does not provide a specific command for this, there are several options available, with the <code>CREATE DATABASE<\/code> command being the most common. Follow this guide to master <code>CREATE DATABASE<\/code> in PostgreSQL.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f91195873de\" data-block-id=\"stk67f91195873de\"><p class=\"stk-block-text__text\">Let dive in!<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f9119587435\" id=\"stk67f9119587435\" data-block-id=\"stk67f9119587435\"><h2 class=\"stk-block-heading__text\">What Is CREATE DATABASE in PostgreSQL?<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911958743b\" data-block-id=\"stk67f911958743b\"><p class=\"stk-block-text__text\">In PostgreSQL, <a href=\"https:\/\/www.postgresql.org\/docs\/current\/sql-createdatabase.html\" target=\"_blank\" rel=\"noopener\"><code>CREATE DATABASE<\/code><\/a> is the statement used to create new databases. Keep in mind that\u2014unlike standard SQL, where a database is typically a collection of schemas within a single catalog\u2014PostgreSQL treats each database as a separate entity.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587446\" data-block-id=\"stk67f9119587446\"><p class=\"stk-block-text__text\">In particular, each Postgres database has its own catalog and operates independently. This means that schemas, tables, and other objects are confined to their respective databases, and you cannot directly access objects across different databases. Thus, cross-database queries are forbidden in PostgreSQL. To achieve similar functionality, you can use multiple schemas within the same database.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911958744a\" data-block-id=\"stk67f911958744a\"><p class=\"stk-block-text__text\"><strong>Note<\/strong>: <code>CREATE DATABASE<\/code> is not part of the SQL standard, which means database creation operations in SQL are implementation-specific.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f9119587452\" id=\"stk67f9119587452\" data-block-id=\"stk67f9119587452\"><h2 class=\"stk-block-heading__text\">Postgres CREATE DATABASE Syntax and Usage<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587454\" data-block-id=\"stk67f9119587454\"><p class=\"stk-block-text__text\">This is the basic syntax to use <code>CREATE DATABASE<\/code> in PostgreSQL:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f5e\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE DATABASE<\/span> db_name;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f61\" data-block-id=\"67f911a1c2f61\"><style>.stk-67f911a1c2f61 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f61-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f61-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f62\" data-v=\"4\" data-block-id=\"67f911a1c2f62\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f62-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f62-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f91195879ea\" data-block-id=\"stk67f91195879ea\"><p class=\"stk-block-text__text\">Where <code>db_name<\/code> is the name of the new Postgres database you want to create.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587a08\" data-block-id=\"stk67f9119587a08\"><p class=\"stk-block-text__text\">A more complete syntax for the Postgres <code>CREATE DATABASE<\/code> command includes a few optional parameters:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f65\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE DATABASE<\/span> db_name<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\">    [ <span class=\"text-product-orange\">WITH<\/span> ] [ OWNER [=] user_name ]<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\">           [ TEMPLATE [=] template ]<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">4<\/span>\n                    <span class=\"codeBlock codeBlock__line\">           [ ENCODING [=] encoding ]<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">5<\/span>\n                    <span class=\"codeBlock codeBlock__line\">           [ STRATEGY [=] strategy ]<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">6<\/span>\n                    <span class=\"codeBlock codeBlock__line\">           [ LOCALE [=] locale ];<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f66\" data-block-id=\"67f911a1c2f66\"><style>.stk-67f911a1c2f66 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f66-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f66-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f67\" data-v=\"4\" data-block-id=\"67f911a1c2f67\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f67-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f67-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587a18\" data-block-id=\"stk67f9119587a18\"><p class=\"stk-block-text__text\">Where:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67f9119587a72\" data-block-id=\"stk67f9119587a72\"><style>.stk-stk67f9119587a72 .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67f9119587a72 {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67f9119587a72\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-09e9142\" data-block-id=\"09e9142\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587a72\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>user_name<\/code>: The role of the user who will own the new database. Use <code>DEFAULT<\/code> to assign ownership to the user executing the command.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-9b9bc7c\" data-block-id=\"9b9bc7c\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587a72\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>template<\/code>: The name of the template database to use for creating the new database. Use <code>DEFAULT<\/code> to use the default template (<code>template1<\/code>).<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-6e5217b\" data-block-id=\"6e5217b\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587a72\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>encoding<\/code>: The <a href=\"https:\/\/www.postgresql.org\/docs\/current\/multibyte.html\" target=\"_blank\" rel=\"noopener\">character set encoding<\/a> for the new database. You can specify a string constant (e.g., <code>'SQL_ASCII'<\/code>), an integer encoding number, or <code>DEFAULT<\/code> to use the encoding of the template database.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-c64c8cf\" data-block-id=\"c64c8cf\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587a72\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>strategy<\/code>: The strategy for creating the new database. The default <code>WAL_LOG<\/code> strategy copies the database block by block, efficiently logging each block in the write-ahead log. The older <code>FILE_COPY<\/code> strategy copies the database at the filesystem level, with a small log entry for each tablespace.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-ba8d180\" data-block-id=\"ba8d180\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587a72\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>locale<\/code>: Sets the <a href=\"https:\/\/www.postgresql.org\/docs\/current\/locale.html\" target=\"_blank\" rel=\"noopener\">default collation<\/a> and character classification in the new database, which affects string sorting (e.g., in queries with <a href=\"https:\/\/www.dbvis.com\/thetable\/sql-order-by-clause-definitive-guide\/\"><code>ORDER BY<\/code><\/a>) and the ordering in text column indexes.<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587ae1\" data-block-id=\"stk67f9119587ae1\"><p class=\"stk-block-text__text\">Remember that other parameters are available. Discover them all through the <a href=\"https:\/\/www.postgresql.org\/docs\/current\/sql-createdatabase.html\" target=\"_blank\" rel=\"noopener\">official documentation<\/a>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587aed\" data-block-id=\"stk67f9119587aed\"><p class=\"stk-block-text__text\"><strong>Notes<\/strong>:<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-icon-list stk-block-icon-list stk-block stk-stk67f9119587af1\" data-block-id=\"stk67f9119587af1\"><style>.stk-stk67f9119587af1 .stk-block-icon-list-item__content{gap:8px !important;align-items:baseline !important;}.stk-stk67f9119587af1 {--stk-icon-list-row-gap:8px !important;--stk-icon-height:8px !important;}<\/style><svg style=\"display:none\"><defs><g id=\"stk-icon-list__icon-svg-def-stk67f9119587af1\"><svg xmlns='http:\/\/www.w3.org\/2000\/svg' viewBox='0 0 100 100'><circle cx='50' cy='50' r='40'><\/circle><\/svg><\/g><\/defs><\/svg><div class=\"stk-block-icon-list__ul stk-block-icon-list--column\"><ul class=\"stk-block-icon-list__group\">\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-9297e2c\" data-block-id=\"9297e2c\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">To create a database, you must be a superuser or have the <code>CREATEDB<\/code> privilege.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-1643456\" data-block-id=\"1643456\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\"><code>CREATE DATABASE<\/code> cannot be executed inside a transaction block, as it is a DDL (Data Definition Language) command.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-4eface9\" data-block-id=\"4eface9\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">By default, a new database is created by cloning the <a href=\"https:\/\/www.postgresql.org\/docs\/current\/manage-ag-templatedbs.html\" target=\"_blank\" rel=\"noopener\"><code>template1<\/code><\/a> system database but you can specify a different template using the <code>TEMPLATE name<\/code> option. For example, <code>TEMPLATE template0<\/code> creates a clean database with only the standard PostgreSQL objects, excluding any user-defined additions from <code>template1<\/code>.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-3156f25\" data-block-id=\"3156f25\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">Errors like \u201ccould not initialize database directory\u201d are often due to insufficient permissions on the data directory, a full disk, or other file system issues.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-dae8cea\" data-block-id=\"dae8cea\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">Database-level configuration parameters (set via <code>ALTER DATABASE<\/code>) and permissions (set via <code>GRANT<\/code>) are not copied from the template database.<\/span><\/div><\/li>\n\n\n\n<li class=\"wp-block-stackable-icon-list-item stk-block-icon-list-item stk-block stk-43246f2\" data-block-id=\"43246f2\"><div class=\"stk-block-icon-list-item__content\"><span class=\"stk--svg-wrapper\"><div class=\"stk--inner-svg\"><svg aria-hidden=\"true\" width=\"32\" height=\"32\"><use xlink:href=\"#stk-icon-list__icon-svg-def-stk67f9119587af1\"><\/use><\/svg><\/div><\/span><span class=\"stk-block-icon-list-item__text\">PostgreSQL does not provide a syntax for creating a database only if it does not already exist (like <a href=\"https:\/\/www.dbvis.com\/thetable\/mysql-create-database-statement-definitive-guide\/\">MySQL's <code>CREATE DATABASE IF NOT EXISTS<\/code><\/a>). In other words, PostgreSQL does not support the <code>CREATE DATABASE IF NOT EXISTS<\/code> syntax.<\/span><\/div><\/li>\n<\/ul><\/div><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f9119587b35\" id=\"stk67f9119587b35\" data-block-id=\"stk67f9119587b35\"><h2 class=\"stk-block-heading__text\">How to Create a Database in PostgreSQL<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587b39\" data-block-id=\"stk67f9119587b39\"><p class=\"stk-block-text__text\">In the following sections, you will learn how to create a database in PostgreSQL using the <code>CREATE DATABASE<\/code> command or a visual database client.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f9119587b43\" id=\"stk67f9119587b43\" data-block-id=\"stk67f9119587b43\"><h3 class=\"stk-block-heading__text\">With CREATE DATABASE<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587b45\" data-block-id=\"stk67f9119587b45\"><p class=\"stk-block-text__text\">Connect to your PostgreSQL server and run the following query to create a new database called <code>company<\/code> with the default options:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f6d\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE DATABASE<\/span> company;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f6e\" data-block-id=\"67f911a1c2f6e\"><style>.stk-67f911a1c2f6e {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f6e-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f6e-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f6f\" data-v=\"4\" data-block-id=\"67f911a1c2f6f\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f6f-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f6f-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587b50\" data-block-id=\"stk67f9119587b50\"><p class=\"stk-block-text__text\">Similarly, you can create a database called <code>ecommerce<\/code> with a specific locale, encoding, and template using the following query:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f70\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE DATABASE<\/span> ecommerce<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">2<\/span>\n                    <span class=\"codeBlock codeBlock__line\">    LOCALE <span class=\"text-brand-green\">'sv_SE.iso885915'<\/span><\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">3<\/span>\n                    <span class=\"codeBlock codeBlock__line\">    ENCODING LATIN9<\/span>\n                <\/span>\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">4<\/span>\n                    <span class=\"codeBlock codeBlock__line\">    TEMPLATE template0;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f71\" data-block-id=\"67f911a1c2f71\"><style>.stk-67f911a1c2f71 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f71-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f71-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f72\" data-v=\"4\" data-block-id=\"67f911a1c2f72\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f72-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f72-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587b5a\" data-block-id=\"stk67f9119587b5a\"><p class=\"stk-block-text__text\">If you are wondering how to see the output of these commands, follow our guide on <a href=\"https:\/\/www.dbvis.com\/thetable\/postgres-list-databases\/\">how to list databases in PostgreSQL<\/a>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f9119587b62\" id=\"stk67f9119587b62\" data-block-id=\"stk67f9119587b62\"><h3 class=\"stk-block-heading__text\">With a Visual Database Client<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119587b63\" data-block-id=\"stk67f9119587b63\"><p class=\"stk-block-text__text\">The procedure outlined above works well, but not having visual feedback on what you are doing can make everything more complex. To combat this, run a Postgres <code>CREATE DATABASE<\/code> query in a visual database client like <a href=\"https:\/\/www.dbvis.com\/database\/postgresql\/\">DbVisualizer<\/a>:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f75\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-1024x608.png\" class=\"attachment-large size-large\" alt=\"Executing the CREATE DATABASE query in DbVisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-1024x608.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-300x178.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-768x456.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-1536x912.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-2048x1216.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-1300x772.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253856074_image-42x25.png 42w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Executing the CREATE DATABASE query in DbVisualizer<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f77\" data-block-id=\"67f911a1c2f77\"><style>.stk-67f911a1c2f77 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f77-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f77-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f78\" data-v=\"4\" data-block-id=\"67f911a1c2f78\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f78-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f78-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119a30c88\" data-block-id=\"stk67f9119a30c88\"><p class=\"stk-block-text__text\">That makes everything easier because you can clearly see that the query was executed successfully and that a new database was added to the server.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119a30ca6\" data-block-id=\"stk67f9119a30ca6\"><p class=\"stk-block-text__text\">But what if you want to create a database without manually running a query, with just with a few clicks? In DbVisualizer, that is possible too!<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119a30cab\" data-block-id=\"stk67f9119a30cab\"><p class=\"stk-block-text__text\"><a href=\"https:\/\/www.dbvis.com\/download\/\">Download DbVisualizer for free<\/a>, connect to your PostgreSQL server, and navigate to the \u201cDatabases\u201d tab on the right:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f7a\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"633\" height=\"381\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253305973_image.png\" class=\"attachment-large size-large\" alt=\"Reaching the PostgreSQL server connection\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253305973_image.png 633w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253305973_image-300x181.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253305973_image-42x25.png 42w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--narrow\">Reaching the PostgreSQL server connection<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f7c\" data-block-id=\"67f911a1c2f7c\"><style>.stk-67f911a1c2f7c {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f7c-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f7c-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f7d\" data-v=\"4\" data-block-id=\"67f911a1c2f7d\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f7d-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f7d-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119b4380d\" data-block-id=\"stk67f9119b4380d\"><p class=\"stk-block-text__text\">Expand the dropdown, right-click on \"Database,\" and select the \u201cCreate Database\u2026\u201d option:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f7e\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"622\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image-1024x622.png\" class=\"attachment-large size-large\" alt=\"Selecting the Create Database\u2026 option\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image-1024x622.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image-300x182.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image-768x467.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image-42x26.png 42w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253329563_image.png 1045w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Selecting the \u201cCreate Database\u201d option<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f80\" data-block-id=\"67f911a1c2f80\"><style>.stk-67f911a1c2f80 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f80-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f80-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f81\" data-v=\"4\" data-block-id=\"67f911a1c2f81\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f81-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f81-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119ce8c05\" data-block-id=\"stk67f9119ce8c05\"><p class=\"stk-block-text__text\">The following modal will appear:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f82\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"1024\" height=\"822\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image-1024x822.png\" class=\"attachment-large size-large\" alt=\"The database creation modal in DbVisualizer\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image-1024x822.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image-300x241.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image-768x617.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image-42x34.png 42w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253348786_image.png 1102w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">The database creation modal in DbVisualizer<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f83\" data-block-id=\"67f911a1c2f83\"><style>.stk-67f911a1c2f83 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f83-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f83-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f84\" data-v=\"4\" data-block-id=\"67f911a1c2f84\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f84-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f84-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f9119ebecee\" data-block-id=\"stk67f9119ebecee\"><p class=\"stk-block-text__text\">Here, you can create a new database by simply filling out the form and clicking the \"Execute\" button:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f85\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--wide thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--wide thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--wide thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"974\" height=\"1024\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image-974x1024.png\" class=\"attachment-large size-large\" alt=\"Filling out the database creation modal\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image-974x1024.png 974w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image-285x300.png 285w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image-768x807.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image-40x42.png 40w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253627203_image.png 1158w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--wide\">Filling out the database creation modal<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f86\" data-block-id=\"67f911a1c2f86\"><style>.stk-67f911a1c2f86 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f86-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f86-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f87\" data-v=\"4\" data-block-id=\"67f911a1c2f87\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f87-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f87-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a0a5210\" data-block-id=\"stk67f911a0a5210\"><p class=\"stk-block-text__text\">As you can see, the generated query is also shown in a dedicated text area! After clicking \"Execute,\" confirm the creation of the database, and it will appear immediately with a special icon in the database list:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"img-wrapper-67f911a1c2f88\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:20px\" data-block-type=\"core\"><section class=\"thetableImage thetableImage__wrapper\">\n    <div class=\"thetableImage thetableImage__container thetableImage__container--dark thetableImage__container--narrow thetableImage__container--shadow\">\n        <div class=\"thetableImage thetableImage__imageWrapper thetableImage__imageWrapper--dark thetableImage__imageWrapper--narrow thetableImage__imageWrapper--shadow\">\n            <div class=\"thetableImage thetableImage__imageContainer thetableImage__imageContainer--dark thetableImage__imageContainer--narrow thetableImage__imageContainer--shadow\">\n                <img decoding=\"async\" width=\"598\" height=\"348\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253711684_image.png\" class=\"attachment-large size-large\" alt=\"Note the newly created ecommerce database\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253711684_image.png 598w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253711684_image-300x175.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/s_3FAF313DE96A9B0CFA7F4CA38D397C1FD3E2863E62A4D9D37536ED26C2DD56DE_1741253711684_image-42x24.png 42w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/>            <\/div>\n        <\/div>\n                    <span class=\"thetableImage thetableImage__imageCaption thetableImage__imageCaption--dark thetableImage__imageCaption--narrow\">Note the newly created ecommerce database<\/span>\n            <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f89\" data-block-id=\"67f911a1c2f89\"><style>.stk-67f911a1c2f89 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f89-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f89-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f8a\" data-v=\"4\" data-block-id=\"67f911a1c2f8a\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f8a-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f8a-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e15\" data-block-id=\"stk67f911a1c2e15\"><p class=\"stk-block-text__text\"><strong><em>Note:<\/em><\/strong><\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e40\" data-block-id=\"stk67f911a1c2e40\"><p class=\"stk-block-text__text\"><em>This database creation feature is available only in DbVisualizer Pro, which offers <a href=\"https:\/\/www.dbvis.com\/features\/\">many other powerful features<\/a>. Grab a <a href=\"https:\/\/www.dbvis.com\/eval\/\">21-day free trial today!<\/a><\/em><\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2e5c\" id=\"stk67f911a1c2e5c\" data-block-id=\"stk67f911a1c2e5c\"><h2 class=\"stk-block-heading__text\">Conclusion<\/h2><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e60\" data-block-id=\"stk67f911a1c2e60\"><p class=\"stk-block-text__text\">In this article, you learned how to use <code>CREATE DATABASE<\/code> in PostgreSQL by exploring its syntax and seeing it in action through a couple of examples.. While you can run that query directly from the command line using <code>psql<\/code>, database management becomes much easier with a powerful, feature-rich database client like <a href=\"https:\/\/www.dbvis.com\/\">DbVisualizer<\/a>, which offers full support for PostgreSQL and <a href=\"https:\/\/www.dbvis.com\/supported-databases\/\">many other databases<\/a>.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2e73\" id=\"stk67f911a1c2e73\" data-block-id=\"stk67f911a1c2e73\"><h2 class=\"stk-block-heading__text\">FAQ<\/h2><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-what-is-the-postgres-psql-create-database-command\" data-block-type=\"core\">What is the Postgres psql create database command?<\/h3>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e79\" data-block-id=\"stk67f911a1c2e79\"><p class=\"stk-block-text__text\">The Postgres psql create database command on Linux is:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f8b\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">sudo -u postgres psql -c <span class=\"text-brand-green\">'<span class=\"text-product-orange\">CREATE DATABASE<\/span> db_name;'<\/span><\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f8c\" data-block-id=\"67f911a1c2f8c\"><style>.stk-67f911a1c2f8c {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f8c-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f8c-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f8d\" data-v=\"4\" data-block-id=\"67f911a1c2f8d\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f8d-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f8d-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e86\" data-block-id=\"stk67f911a1c2e86\"><p class=\"stk-block-text__text\">The psql command connects to PostgreSQL as the <code>postgres<\/code> user. Then, it uses the <code>-c<\/code> flag to runs the <code>CREATE DATABASE<\/code> command directly.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e90\" data-block-id=\"stk67f911a1c2e90\"><p class=\"stk-block-text__text\">Then, grant all permissions to the database with:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f8e\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">sudo -u postgres psql -c <span class=\"text-brand-green\">'<span class=\"text-product-orange\">GRANT<\/span> <span class=\"text-product-orange\">ALL<\/span> <span class=\"text-product-orange\">PRIVILEGES<\/span> on <span class=\"text-product-orange\">DATABASE<\/span> db_name to user_name;'<\/span><\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f8f\" data-block-id=\"67f911a1c2f8f\"><style>.stk-67f911a1c2f8f {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f8f-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f8f-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f90\" data-v=\"4\" data-block-id=\"67f911a1c2f90\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f90-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f90-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2e97\" data-block-id=\"stk67f911a1c2e97\"><p class=\"stk-block-text__text\">This assigns full permissions to <code>user_name<\/code>, allowing them to manage the database. Note that both commands require superuser privileges, hence <code>sudo -u postgres<\/code> .<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2ea1\" id=\"stk67f911a1c2ea1\" data-block-id=\"stk67f911a1c2ea1\"><h3 class=\"stk-block-heading__text\">How to create a PostgreSQL database from the bash?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2ea3\" data-block-id=\"stk67f911a1c2ea3\"><p class=\"stk-block-text__text\">To create a PostgreSQL database from the bash shell without using <code>psql<\/code>, run the <a href=\"https:\/\/www.postgresql.org\/docs\/current\/app-createdb.html\" target=\"_blank\" rel=\"noopener\"><code>createdb<\/code><\/a> command on your Linux PostgreSQL server:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f91\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\">sudo -u postgres createdb db_name<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f92\" data-block-id=\"67f911a1c2f92\"><style>.stk-67f911a1c2f92 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f92-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f92-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f93\" data-v=\"4\" data-block-id=\"67f911a1c2f93\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f93-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f93-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2eb1\" data-block-id=\"stk67f911a1c2eb1\"><p class=\"stk-block-text__text\">This creates <code>db_name<\/code> with default settings as the <code>postgres<\/code> user.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2ebb\" id=\"stk67f911a1c2ebb\" data-block-id=\"stk67f911a1c2ebb\"><h3 class=\"stk-block-heading__text\">What are the privileges required to launch CREATE DATABASE in PostgreSQL?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2ebd\" data-block-id=\"stk67f911a1c2ebd\"><p class=\"stk-block-text__text\">To run <code>CREATE DATABASE<\/code> in PostgreSQL, you must be a superuser or have the <code>CREATEDB<\/code> privilege. To grant the <code>CREATEDB<\/code> privilege, use:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f94\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">ALTER<\/span> ROLE user_name CREATEDB;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f95\" data-block-id=\"67f911a1c2f95\"><style>.stk-67f911a1c2f95 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f95-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f95-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f96\" data-v=\"4\" data-block-id=\"67f911a1c2f96\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f96-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f96-inner-blocks\">\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2ecb\" data-block-id=\"stk67f911a1c2ecb\"><p class=\"stk-block-text__text\">This allows <code>user_name<\/code> to create databases without full superuser rights.<\/p><\/div>\n\n\n\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2ed1\" id=\"stk67f911a1c2ed1\" data-block-id=\"stk67f911a1c2ed1\"><h3 class=\"stk-block-heading__text\">How to create a database schema in PostgreSQL?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2ed3\" data-block-id=\"stk67f911a1c2ed3\"><p class=\"stk-block-text__text\">In PostgreSQL, schemas organize database objects within a database. To create a new schema, connect to the database and run the following <a href=\"https:\/\/www.postgresql.org\/docs\/current\/sql-createschema.html\" target=\"_blank\" rel=\"noopener\"><code>CREATE SCHEMA<\/code><\/a> query:<\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div id=\"pre-wrapper-67f911a1c2f97\" class=\"wp-block-group has-dbvis-light-yellow-background-color has-background is-layout-flow wp-block-group-is-layout-flow\" style=\"padding-top:0px\" data-block-type=\"core\"><section class=\"codeBlock codeBlock__wrapper\">\n    <div class=\"codeBlock codeBlock__copyWrapper\">\n        <a class=\"codeBlock codeBlock__copyCodeButton\">Copy<\/a>\n        <pre class=\"codeBlock codeBlock__container\">\n        <div class=\"codeBlock codeBlock__codeBlockNumber\"><\/div>\n        <code class=\"codeBlock codeBlock__linesContainer\">\n                            <span class=\"codeBlock codeBlock__lineContainer\">\n                    <span class=\"codeBlock codeBlock__lineCount\">1<\/span>\n                    <span class=\"codeBlock codeBlock__line\"><span class=\"text-product-orange\">CREATE<\/span> <span class=\"text-product-orange\">SCHEMA<\/span> schema_name;<\/span>\n                <\/span>\n                    <\/code>\n    <\/pre>\n    <\/div>\n<\/section>\n<\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#f9f9e1\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-67f911a1c2f98\" data-block-id=\"67f911a1c2f98\"><style>.stk-67f911a1c2f98 {margin-top:0px !important;margin-bottom:0px !important;}.stk-67f911a1c2f98-column{max-width:672px !important;min-width:auto !important;justify-content:left !important;}<\/style><div class=\"stk-row stk-inner-blocks has-text-align-left stk-block-content stk-content-align stk-67f911a1c2f98-column stk--flex alignfull\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-67f911a1c2f99\" data-v=\"4\" data-block-id=\"67f911a1c2f99\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-67f911a1c2f99-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-67f911a1c2f99-inner-blocks\">\n<div class=\"wp-block-stackable-heading stk-block-heading stk-block-heading--v2 stk-block stk-stk67f911a1c2ee0\" id=\"stk67f911a1c2ee0\" data-block-id=\"stk67f911a1c2ee0\"><h3 class=\"stk-block-heading__text\">Why use a visual database client to create a database in Postgres?<\/h3><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-stk67f911a1c2ee2\" data-block-id=\"stk67f911a1c2ee2\"><p class=\"stk-block-text__text\">Using a visual database client like DbVisualizer to create a database in Postgres offers several advantages. It provides an intuitive, user-friendly interface, making database creation and management much easier compared to using command-line tools. With DbVisualizer, you can visually see your queries, monitor execution, and access powerful features like drag-and-drop query creation and query optimization. <a href=\"https:\/\/www.dbvis.com\/eval\/\">Test everything it has to offer today!<\/a><\/p><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" data-block-type=\"core\" data-block-type=\"core\" data-block-type=\"core\">\n<div class=\"wp-block-stackable-columns alignfull stk-block-columns stk-block stk-1d92408 stk-block-background\" data-block-id=\"1d92408\"><style>.stk-1d92408 {background-color:var(--stk-global-color-70050, #f9f9e1) !important;margin-bottom:0px !important;}.stk-1d92408:before{background-color:var(--stk-global-color-70050, #f9f9e1) !important;}<\/style><div class=\"stk-row stk-inner-blocks stk-block-content stk-content-align stk-1d92408-column alignwide\">\n<div class=\"wp-block-stackable-column stk-block-column stk-column stk-block stk-b8a8e51\" data-v=\"4\" data-block-id=\"b8a8e51\"><div class=\"stk-column-wrapper stk-block-column__content stk-container stk-b8a8e51-container stk--no-background stk--no-padding\"><div class=\"stk-block-content stk-inner-blocks stk-b8a8e51-inner-blocks\">\n<div class=\"wp-block-stackable-image stk-block-image stk-block stk-d9669e0\" data-block-id=\"d9669e0\"><figure><a class=\"stk-link\" href=\"\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"stk-img-wrapper stk-image--shape-stretch\"><img decoding=\"async\" class=\"stk-img wp-image-26081\" src=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-scaled.png\" width=\"2560\" height=\"577\" alt=\"Dbvis download link img\" srcset=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-scaled.png 2560w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-300x68.png 300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1024x231.png 1024w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-768x173.png 768w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1536x346.png 1536w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-2048x462.png 2048w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-1300x293.png 1300w, https:\/\/www.dbvis.com\/wp-content\/uploads\/2022\/12\/Banner-1-42x9.png 42w\" sizes=\"(max-width: 2560px) 100vw, 2560px\" \/><\/span><\/a><\/figure><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n","protected":false},"excerpt":{"rendered":"<p>intro Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance. Adding databases to a new database server is one of the most common tasks performed by DBAs or database users. While standard SQL does not provide a specific command [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[25],"class_list":["post-23906","post","type-post","status-publish","format-standard","hentry","category-thetable","tag-postgresql"],"acf":{"updated_date":"20250324","featured":false,"prio":"","highlighted":false,"type":"Guide","length":"6 min","author":[8009],"tools_used":[12272]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>CREATE DATABASE in PostgreSQL: A Complete Guide<\/title>\n<meta name=\"description\" content=\"Let&#039;s learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CREATE DATABASE in PostgreSQL: A Complete Guide\" \/>\n<meta property=\"og:description\" content=\"Let&#039;s learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"DbVisualizer\" \/>\n<meta property=\"article:author\" content=\"Antonello Zanini\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-30T08:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/og-359.png\" \/>\n<meta name=\"author\" content=\"Antonello Zanini\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"CREATE DATABASE in PostgreSQL: A Complete Guide\" \/>\n<meta name=\"twitter:description\" content=\"Let&#039;s learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.\" \/>\n<meta name=\"twitter:creator\" content=\"@dbvisualizer\" \/>\n<meta name=\"twitter:site\" content=\"@dbvisualizer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antonello Zanini\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CREATE DATABASE in PostgreSQL: A Complete Guide","description":"Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.","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:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/","og_locale":"en_US","og_type":"article","og_title":"CREATE DATABASE in PostgreSQL: A Complete Guide","og_description":"Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.","og_url":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/","og_site_name":"DbVisualizer","article_author":"Antonello Zanini","article_published_time":"2025-04-30T08:00:00+00:00","og_image":[{"url":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/09\/og-359.png","type":"","width":"","height":""}],"author":"Antonello Zanini","twitter_card":"summary_large_image","twitter_title":"CREATE DATABASE in PostgreSQL: A Complete Guide","twitter_description":"Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.","twitter_creator":"@dbvisualizer","twitter_site":"@dbvisualizer","twitter_misc":{"Written by":"Antonello Zanini","Est. reading time":"6 min"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/#article","isPartOf":{"@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/"},"author":{"name":"Meryem Oubadah","@id":"https:\/\/www.dbvis.com\/#\/schema\/person\/236b1071efe73cade4c5e67ee4d012b9"},"headline":"CREATE DATABASE in PostgreSQL: A Complete Guide","datePublished":"2025-04-30T08:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/"},"wordCount":1134,"publisher":{"@id":"https:\/\/www.dbvis.com\/#organization"},"keywords":["POSTGRESQL"],"articleSection":["TheTable"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/","url":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/","name":"CREATE DATABASE in PostgreSQL: A Complete Guide","isPartOf":{"@id":"https:\/\/www.dbvis.com\/#website"},"datePublished":"2025-04-30T08:00:00+00:00","description":"Let's learn everything you need to know about CREATE DATABASE in PostgreSQL, the statement you can employ to create new databases in your Postgres instance.","breadcrumb":{"@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbvis.com\/thetable\/create-database-in-postgresql-a-complete-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hem","item":"https:\/\/www.dbvis.com\/"},{"@type":"ListItem","position":2,"name":"CREATE DATABASE in PostgreSQL: A Complete Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.dbvis.com\/#website","url":"https:\/\/www.dbvis.com\/","name":"DbVisualizer","description":"","publisher":{"@id":"https:\/\/www.dbvis.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbvis.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbvis.com\/#organization","name":"DbVisualizer","alternateName":"DbVis","url":"https:\/\/www.dbvis.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbvis.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/08\/dbvisualizer_logo_squircle.svg","contentUrl":"https:\/\/www.dbvis.com\/wp-content\/uploads\/2023\/08\/dbvisualizer_logo_squircle.svg","width":72,"height":72,"caption":"DbVisualizer"},"image":{"@id":"https:\/\/www.dbvis.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/dbvisualizer"]},{"@type":"Person","@id":"https:\/\/www.dbvis.com\/#\/schema\/person\/236b1071efe73cade4c5e67ee4d012b9","name":"Meryem Oubadah","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/8b6a47782e12b45fbba528caa758628a.jpg?ver=1776424903","url":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/8b6a47782e12b45fbba528caa758628a.jpg?ver=1776424903","contentUrl":"https:\/\/www.dbvis.com\/wp-content\/litespeed\/avatar\/8b6a47782e12b45fbba528caa758628a.jpg?ver=1776424903","caption":"Meryem Oubadah"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/23906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/comments?post=23906"}],"version-history":[{"count":8,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/23906\/revisions"}],"predecessor-version":[{"id":23996,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/posts\/23906\/revisions\/23996"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/thetable-tool\/12272"},{"embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/thetable-author\/8009"}],"wp:attachment":[{"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/media?parent=23906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/categories?post=23906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbvis.com\/wp-json\/wp\/v2\/tags?post=23906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}