E
E
empty_project2019-02-27 14:14:27
PostgreSQL
empty_project, 2019-02-27 14:14:27

Syntax error (example position: "ON"). Mistake?

CREATE DATABASE MyDB 
ON 
  (NAME = MyDBroot,  
  FILENAME = "C:\mssql2k\MSSQL\data\mydbroot.mdf", 
  SIZE = 8MB, 
  MAXSIZE = 9MB, 
  FILEGROWTH = 100KB), 
  (NAME = MyDBdata1,  
  FILENAME = "C:\mssql2k\MSSQL\data\mydbdata1.ndf", 
  SIZE = 1000MB, 
  MAXSIZE = 1500MB, 
  FILEGROWTH = 100MB) 
LOG ON 
  (NAME = Logdata1,
  FILENAME = "D:\log_files\logdata1.ldf", 
  SIZE = 1000MB, 
  MAXSIZE = 1500MB, 
  FILEGROWTH = 100MB)

What's wrong with this code? Why is an error being thrown? postgre version 10.6

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2019-02-27
@empty_project

Where is there no error?
Postgresql is specified in the tag, where the create database syntax is as follows: https://www.postgresql.org/docs/current/sql-create
... another DBMS.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question