Laravel migration to add field to table, but Laravel adds double quotes

Question

I have added this migration to add fields to my admission table. The problem is that it creates some fields in postgres with double quotes.
Bellow are two fields from the same migration. One was created with quotes and the other without.

Why does this happen? I thought it might be todo with the data type, but I have other integer fields that where created with quotes aswell.

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class addReferralFields extends Migration
{
    public function up()
    {
        Schema::table('admission', function (Blueprint $table) {
            if (!Schema::hasColumn('admission', 'appointmentDate')) $table->timestampTz('appointmentDate')->nullable();
            if (!Schema::hasColumn('admission', 'appointment_pre_employment_status')) $table->integer('appointment_pre_employment_status')->nullable();



        });
    }
}

ADMISSION TABLE

  "apointmentDate" timestamp(0) with time zone,
  appointment_pre_employment_status integer,

Seems like its the case in the name of the field. If the name has capitals then it puts it in quotes. — morne, Oct 09 '19 at 08:47
this is the answer I think: https://stackoverflow.com/a/55297938/3256489 — 4givN, Oct 09 '19 at 08:54

score 0 · Accepted Answer · answered Oct 10 '19 at 08:10

0

All I did was run another migration to set all fields names to lowercase.

public function up()
{
    Schema::table('admission', function(Blueprint $table) {

        $table->renameColumn('"apointmentDate"', 'apointmentdate');

    });
}

answered Oct 10 '19 at 08:10

morne

4,035
9
50
96

Laravel migration to add field to table, but Laravel adds double quotes

1 Answers1