Symfony Profiler

SELECT
  quote_ident(r.conname) as conname,
  pg_get_constraintdef(r.oid, true) as condef
FROM
  pg_constraint r
  JOIN pg_class AS tc ON tc.oid = r.conrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
WHERE
  r.conrelid IN (
    SELECT
      c.oid
    FROM
      pg_class c,
      pg_namespace n
    WHERE
      n.oid = c.relnamespace
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND r.contype = 'f'

SELECT                  quote_ident(r.conname) as conname,
                  pg_get_constraintdef(r.oid, true) as condef
                  FROM pg_constraint r
                      JOIN pg_class AS tc ON tc.oid = r.conrelid
                      JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                  WHERE r.conrelid IN
                  (
                      SELECT c.oid
                      FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND r.contype = 'f';

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'homepagemanager'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT
  t0.id AS id_1,
  t0.maxIdleTime AS maxidletime_2,
  t0.environment AS environment_3,
  t0.version AS version_4,
  t0.siteEmail AS siteemail_5,
  t0.dbServerAddress AS dbserveraddress_6,
  t0.dbServerPort AS dbserverport_7,
  t0.dbServerAccountUserName AS dbserveraccountusername_8,
  t0.dbServerAccountPassword AS dbserveraccountpassword_9,
  t0.dbDatabaseName AS dbdatabasename_10,
  t0.smtpServerAddress AS smtpserveraddress_11,
  t0.mailerTransport AS mailertransport_12,
  t0.mailerAuthMode AS mailerauthmode_13,
  t0.mailerUseSecureConnection AS mailerusesecureconnection_14,
  t0.mailerUser AS maileruser_15,
  t0.mailerPassword AS mailerpassword_16,
  t0.mailerPort AS mailerport_17,
  t0.mailerSpool AS mailerspool_18,
  t0.mailerFlushQueueFrequency AS mailerflushqueuefrequency_19,
  t0.mailerDeliveryAddresses AS mailerdeliveryaddresses_20,
  t0.ldapAll AS ldapall_21,
  t0.aDLDAPServerAddress AS adldapserveraddress_22,
  t0.aDLDAPServerPort AS adldapserverport_23,
  t0.aDLDAPServerOu AS adldapserverou_24,
  t0.aDLDAPServerAccountUserName AS adldapserveraccountusername_25,
  t0.aDLDAPServerAccountPassword AS adldapserveraccountpassword_26,
  t0.ldapExePath AS ldapexepath_27,
  t0.ldapExeFilename AS ldapexefilename_28,
  t0.ldapMapperEmail AS ldapmapperemail_29,
  t0.aDLDAPServerAddress2 AS adldapserveraddress2_30,
  t0.aDLDAPServerPort2 AS adldapserverport2_31,
  t0.aDLDAPServerOu2 AS adldapserverou2_32,
  t0.aDLDAPServerAccountUserName2 AS adldapserveraccountusername2_33,
  t0.aDLDAPServerAccountPassword2 AS adldapserveraccountpassword2_34,
  t0.ldapExePath2 AS ldapexepath2_35,
  t0.ldapExeFilename2 AS ldapexefilename2_36,
  t0.ldapMapperEmail2 AS ldapmapperemail2_37,
  t0.enableAutoAssignmentInstitutionalScope AS enableautoassignmentinstitutionalscope_38,
  t0.pacsvendorSlideManagerDBServerAddress AS pacsvendorslidemanagerdbserveraddress_39,
  t0.pacsvendorSlideManagerDBServerPort AS pacsvendorslidemanagerdbserverport_40,
  t0.pacsvendorSlideManagerDBUserName AS pacsvendorslidemanagerdbusername_41,
  t0.pacsvendorSlideManagerDBPassword AS pacsvendorslidemanagerdbpassword_42,
  t0.pacsvendorSlideManagerDBName AS pacsvendorslidemanagerdbname_43,
  t0.institutionurl AS institutionurl_44,
  t0.institutionname AS institutionname_45,
  t0.departmenturl AS departmenturl_46,
  t0.departmentname AS departmentname_47,
  t0.subinstitutionurl AS subinstitutionurl_48,
  t0.subinstitutionname AS subinstitutionname_49,
  t0.showCopyrightOnFooter AS showcopyrightonfooter_50,
  t0.maintenance AS maintenance_51,
  t0.maintenanceenddate AS maintenanceenddate_52,
  t0.maintenancelogoutmsg AS maintenancelogoutmsg_53,
  t0.maintenanceloginmsg AS maintenanceloginmsg_54,
  t0.globalNoteLogin AS globalnotelogin_55,
  t0.scanuploadpath AS scanuploadpath_56,
  t0.employeesuploadpath AS employeesuploadpath_57,
  t0.avataruploadpath AS avataruploadpath_58,
  t0.fellappuploadpath AS fellappuploadpath_59,
  t0.resappuploadpath AS resappuploadpath_60,
  t0.vacrequploadpath AS vacrequploadpath_61,
  t0.transresuploadpath AS transresuploadpath_62,
  t0.callloguploadpath AS callloguploadpath_63,
  t0.crnuploadpath AS crnuploadpath_64,
  t0.mainHomeTitle AS mainhometitle_65,
  t0.listManagerTitle AS listmanagertitle_66,
  t0.eventLogTitle AS eventlogtitle_67,
  t0.siteSettingsTitle AS sitesettingstitle_68,
  t0.contentAboutPage AS contentaboutpage_69,
  t0.underLoginMsgUser AS underloginmsguser_70,
  t0.underLoginMsgScan AS underloginmsgscan_71,
  t0.backupUpdateDatetimeFellApp AS backupupdatedatetimefellapp_72,
  t0.libreOfficeConvertToPDFPathFellApp AS libreofficeconverttopdfpathfellapp_73,
  t0.libreOfficeConvertToPDFPathFellAppLinux AS libreofficeconverttopdfpathfellapplinux_74,
  t0.libreOfficeConvertToPDFFilenameFellApp AS libreofficeconverttopdffilenamefellapp_75,
  t0.libreOfficeConvertToPDFFilenameFellAppLinux AS libreofficeconverttopdffilenamefellapplinux_76,
  t0.libreOfficeConvertToPDFArgumentsdFellApp AS libreofficeconverttopdfargumentsdfellapp_77,
  t0.libreOfficeConvertToPDFArgumentsdFellAppLinux AS libreofficeconverttopdfargumentsdfellapplinux_78,
  t0.pdftkPathFellApp AS pdftkpathfellapp_79,
  t0.pdftkPathFellAppLinux AS pdftkpathfellapplinux_80,
  t0.pdftkFilenameFellApp AS pdftkfilenamefellapp_81,
  t0.pdftkFilenameFellAppLinux AS pdftkfilenamefellapplinux_82,
  t0.pdftkArgumentsFellApp AS pdftkargumentsfellapp_83,
  t0.pdftkArgumentsFellAppLinux AS pdftkargumentsfellapplinux_84,
  t0.gsPathFellApp AS gspathfellapp_85,
  t0.gsPathFellAppLinux AS gspathfellapplinux_86,
  t0.gsFilenameFellApp AS gsfilenamefellapp_87,
  t0.gsFilenameFellAppLinux AS gsfilenamefellapplinux_88,
  t0.gsArgumentsFellApp AS gsargumentsfellapp_89,
  t0.gsArgumentsFellAppLinux AS gsargumentsfellapplinux_90,
  t0.wkhtmltopdfpath AS wkhtmltopdfpath_91,
  t0.wkhtmltopdfpathLinux AS wkhtmltopdfpathlinux_92,
  t0.phantomjs AS phantomjs_93,
  t0.phantomjsLinux AS phantomjslinux_94,
  t0.rasterize AS rasterize_95,
  t0.rasterizeLinux AS rasterizelinux_96,
  t0.lisDBServerAddress AS lisdbserveraddress_97,
  t0.lisDBServerPort AS lisdbserverport_98,
  t0.lisDBAccountUserName AS lisdbaccountusername_99,
  t0.lisDBAccountPassword AS lisdbaccountpassword_100,
  t0.lisDBName AS lisdbname_101,
  t0.lisName AS lisname_102,
  t0.lisVersion AS lisversion_103,
  t0.lisDBServerAddressTest AS lisdbserveraddresstest_104,
  t0.lisDBServerPortTest AS lisdbserverporttest_105,
  t0.lisDBAccountUserNameTest AS lisdbaccountusernametest_106,
  t0.lisDBAccountPasswordTest AS lisdbaccountpasswordtest_107,
  t0.lisDBNameTest AS lisdbnametest_108,
  t0.LISNameTest AS lisnametest_109,
  t0.LISVersionTest AS lisversiontest_110,
  t0.lisDBServerAddressDevelopment AS lisdbserveraddressdevelopment_111,
  t0.lisDBServerPortDevelopment AS lisdbserverportdevelopment_112,
  t0.lisDBAccountUserNameDevelopment AS lisdbaccountusernamedevelopment_113,
  t0.lisDBAccountPasswordDevelopment AS lisdbaccountpassworddevelopment_114,
  t0.lisDBNameDevelopment AS lisdbnamedevelopment_115,
  t0.LISNameDevelopment AS lisnamedevelopment_116,
  t0.LISVersionDevelopment AS lisversiondevelopment_117,
  t0.academicYearStart AS academicyearstart_118,
  t0.academicYearEnd AS academicyearend_119,
  t0.liveSiteRootUrl AS livesiterooturl_120,
  t0.enableMetaphone AS enablemetaphone_121,
  t0.pathMetaphone AS pathmetaphone_122,
  t0.initialConfigurationCompleted AS initialconfigurationcompleted_123,
  t0.networkDrivePath AS networkdrivepath_124,
  t0.permittedFailedLoginAttempt AS permittedfailedloginattempt_125,
  t0.captchaSiteKey AS captchasitekey_126,
  t0.captchaSecretKey AS captchasecretkey_127,
  t0.captchaEnabled AS captchaenabled_128,
  t0.noticeAttemptingPasswordResetLDAP AS noticeattemptingpasswordresetldap_129,
  t0.loginInstruction AS logininstruction_130,
  t0.noticeSignUpNoCwid AS noticesignupnocwid_131,
  t0.noticeHasLdapAccount AS noticehasldapaccount_132,
  t0.noticeLdapName AS noticeldapname_133,
  t0.calllogResources AS calllogresources_134,
  t0.logoWidth AS logowidth_135,
  t0.logoHeight AS logoheight_136,
  t0.connectionChannel AS connectionchannel_137,
  t0.urlConnectionChannel AS urlconnectionchannel_138,
  t0.transresProjectSelectionNote AS transresprojectselectionnote_139,
  t0.transresHumanSubjectName AS transreshumansubjectname_140,
  t0.transresAnimalSubjectName AS transresanimalsubjectname_141,
  t0.transresBusinessEntityName AS transresbusinessentityname_142,
  t0.transresBusinessEntityAbbreviation AS transresbusinessentityabbreviation_143,
  t0.emailCriticalError AS emailcriticalerror_144,
  t0.restartServerErrorCounter AS restartservererrorcounter_145,
  t0.remoteAccessUrl AS remoteaccessurl_146,
  t0.externalMonitorUrl AS externalmonitorurl_147,
  t0.monitorScript AS monitorscript_148,
  t0.monitorCheckInterval AS monitorcheckinterval_149,
  t0.sendEmailUserAdded AS sendemailuseradded_150,
  t0.dbBackupConfig AS dbbackupconfig_151,
  t0.filesBackupConfig AS filesbackupconfig_152,
  t0.secretKey AS secretkey_153,
  t0.instanceId AS instanceid_154,
  t0.showTenantsHomepage AS showtenantshomepage_155,
  t0.defaultPrimaryPublicUserIdType_id AS defaultprimarypublicuseridtype_id_156,
  t0.ldapMapperPrimaryPublicUserIdType_id AS ldapmapperprimarypublicuseridtype_id_157,
  t0.ldapMapperPrimaryPublicUserIdType2_id AS ldapmapperprimarypublicuseridtype2_id_158,
  t0.autoAssignInstitution_id AS autoassigninstitution_id_159,
  t0.fellappSiteParameter_id AS fellappsiteparameter_id_160,
  t0.resappSiteParameter_id AS resappsiteparameter_id_161,
  t0.calllogSiteParameter_id AS calllogsiteparameter_id_162,
  t0.crnSiteParameter_id AS crnsiteparameter_id_163,
  t0.dashboardSiteParameter_id AS dashboardsiteparameter_id_164,
  t0.navbarFilterInstitution1_id AS navbarfilterinstitution1_id_165,
  t0.navbarFilterInstitution2_id AS navbarfilterinstitution2_id_166,
  t0.defaultDeidentifierAccessionType_id AS defaultdeidentifieraccessiontype_id_167,
  t0.defaultScanAccessionType_id AS defaultscanaccessiontype_id_168,
  t0.defaultScanMrnType_id AS defaultscanmrntype_id_169,
  t0.defaultScanDelivery_id AS defaultscandelivery_id_170,
  t0.defaultOrganizationRecipient_id AS defaultorganizationrecipient_id_171,
  t0.defaultScanner_id AS defaultscanner_id_172,
  t0.transresDashboardInstitution_id AS transresdashboardinstitution_id_173,
  t0.vacreqSiteParameter_id AS vacreqsiteparameter_id_174,
  t0.telephonySiteParameter_id AS telephonysiteparameter_id_175,
  t0.authUserGroup_id AS authusergroup_id_176,
  t0.authServerNetwork_id AS authservernetwork_id_177,
  t0.authPartnerServer_id AS authpartnerserver_id_178
FROM
  user_siteparameters t0

SELECT t0.id AS id_1, t0.maxIdleTime AS maxidletime_2, t0.environment AS environment_3, t0.version AS version_4, t0.siteEmail AS siteemail_5, t0.dbServerAddress AS dbserveraddress_6, t0.dbServerPort AS dbserverport_7, t0.dbServerAccountUserName AS dbserveraccountusername_8, t0.dbServerAccountPassword AS dbserveraccountpassword_9, t0.dbDatabaseName AS dbdatabasename_10, t0.smtpServerAddress AS smtpserveraddress_11, t0.mailerTransport AS mailertransport_12, t0.mailerAuthMode AS mailerauthmode_13, t0.mailerUseSecureConnection AS mailerusesecureconnection_14, t0.mailerUser AS maileruser_15, t0.mailerPassword AS mailerpassword_16, t0.mailerPort AS mailerport_17, t0.mailerSpool AS mailerspool_18, t0.mailerFlushQueueFrequency AS mailerflushqueuefrequency_19, t0.mailerDeliveryAddresses AS mailerdeliveryaddresses_20, t0.ldapAll AS ldapall_21, t0.aDLDAPServerAddress AS adldapserveraddress_22, t0.aDLDAPServerPort AS adldapserverport_23, t0.aDLDAPServerOu AS adldapserverou_24, t0.aDLDAPServerAccountUserName AS adldapserveraccountusername_25, t0.aDLDAPServerAccountPassword AS adldapserveraccountpassword_26, t0.ldapExePath AS ldapexepath_27, t0.ldapExeFilename AS ldapexefilename_28, t0.ldapMapperEmail AS ldapmapperemail_29, t0.aDLDAPServerAddress2 AS adldapserveraddress2_30, t0.aDLDAPServerPort2 AS adldapserverport2_31, t0.aDLDAPServerOu2 AS adldapserverou2_32, t0.aDLDAPServerAccountUserName2 AS adldapserveraccountusername2_33, t0.aDLDAPServerAccountPassword2 AS adldapserveraccountpassword2_34, t0.ldapExePath2 AS ldapexepath2_35, t0.ldapExeFilename2 AS ldapexefilename2_36, t0.ldapMapperEmail2 AS ldapmapperemail2_37, t0.enableAutoAssignmentInstitutionalScope AS enableautoassignmentinstitutionalscope_38, t0.pacsvendorSlideManagerDBServerAddress AS pacsvendorslidemanagerdbserveraddress_39, t0.pacsvendorSlideManagerDBServerPort AS pacsvendorslidemanagerdbserverport_40, t0.pacsvendorSlideManagerDBUserName AS pacsvendorslidemanagerdbusername_41, t0.pacsvendorSlideManagerDBPassword AS pacsvendorslidemanagerdbpassword_42, t0.pacsvendorSlideManagerDBName AS pacsvendorslidemanagerdbname_43, t0.institutionurl AS institutionurl_44, t0.institutionname AS institutionname_45, t0.departmenturl AS departmenturl_46, t0.departmentname AS departmentname_47, t0.subinstitutionurl AS subinstitutionurl_48, t0.subinstitutionname AS subinstitutionname_49, t0.showCopyrightOnFooter AS showcopyrightonfooter_50, t0.maintenance AS maintenance_51, t0.maintenanceenddate AS maintenanceenddate_52, t0.maintenancelogoutmsg AS maintenancelogoutmsg_53, t0.maintenanceloginmsg AS maintenanceloginmsg_54, t0.globalNoteLogin AS globalnotelogin_55, t0.scanuploadpath AS scanuploadpath_56, t0.employeesuploadpath AS employeesuploadpath_57, t0.avataruploadpath AS avataruploadpath_58, t0.fellappuploadpath AS fellappuploadpath_59, t0.resappuploadpath AS resappuploadpath_60, t0.vacrequploadpath AS vacrequploadpath_61, t0.transresuploadpath AS transresuploadpath_62, t0.callloguploadpath AS callloguploadpath_63, t0.crnuploadpath AS crnuploadpath_64, t0.mainHomeTitle AS mainhometitle_65, t0.listManagerTitle AS listmanagertitle_66, t0.eventLogTitle AS eventlogtitle_67, t0.siteSettingsTitle AS sitesettingstitle_68, t0.contentAboutPage AS contentaboutpage_69, t0.underLoginMsgUser AS underloginmsguser_70, t0.underLoginMsgScan AS underloginmsgscan_71, t0.backupUpdateDatetimeFellApp AS backupupdatedatetimefellapp_72, t0.libreOfficeConvertToPDFPathFellApp AS libreofficeconverttopdfpathfellapp_73, t0.libreOfficeConvertToPDFPathFellAppLinux AS libreofficeconverttopdfpathfellapplinux_74, t0.libreOfficeConvertToPDFFilenameFellApp AS libreofficeconverttopdffilenamefellapp_75, t0.libreOfficeConvertToPDFFilenameFellAppLinux AS libreofficeconverttopdffilenamefellapplinux_76, t0.libreOfficeConvertToPDFArgumentsdFellApp AS libreofficeconverttopdfargumentsdfellapp_77, t0.libreOfficeConvertToPDFArgumentsdFellAppLinux AS libreofficeconverttopdfargumentsdfellapplinux_78, t0.pdftkPathFellApp AS pdftkpathfellapp_79, t0.pdftkPathFellAppLinux AS pdftkpathfellapplinux_80, t0.pdftkFilenameFellApp AS pdftkfilenamefellapp_81, t0.pdftkFilenameFellAppLinux AS pdftkfilenamefellapplinux_82, t0.pdftkArgumentsFellApp AS pdftkargumentsfellapp_83, t0.pdftkArgumentsFellAppLinux AS pdftkargumentsfellapplinux_84, t0.gsPathFellApp AS gspathfellapp_85, t0.gsPathFellAppLinux AS gspathfellapplinux_86, t0.gsFilenameFellApp AS gsfilenamefellapp_87, t0.gsFilenameFellAppLinux AS gsfilenamefellapplinux_88, t0.gsArgumentsFellApp AS gsargumentsfellapp_89, t0.gsArgumentsFellAppLinux AS gsargumentsfellapplinux_90, t0.wkhtmltopdfpath AS wkhtmltopdfpath_91, t0.wkhtmltopdfpathLinux AS wkhtmltopdfpathlinux_92, t0.phantomjs AS phantomjs_93, t0.phantomjsLinux AS phantomjslinux_94, t0.rasterize AS rasterize_95, t0.rasterizeLinux AS rasterizelinux_96, t0.lisDBServerAddress AS lisdbserveraddress_97, t0.lisDBServerPort AS lisdbserverport_98, t0.lisDBAccountUserName AS lisdbaccountusername_99, t0.lisDBAccountPassword AS lisdbaccountpassword_100, t0.lisDBName AS lisdbname_101, t0.lisName AS lisname_102, t0.lisVersion AS lisversion_103, t0.lisDBServerAddressTest AS lisdbserveraddresstest_104, t0.lisDBServerPortTest AS lisdbserverporttest_105, t0.lisDBAccountUserNameTest AS lisdbaccountusernametest_106, t0.lisDBAccountPasswordTest AS lisdbaccountpasswordtest_107, t0.lisDBNameTest AS lisdbnametest_108, t0.LISNameTest AS lisnametest_109, t0.LISVersionTest AS lisversiontest_110, t0.lisDBServerAddressDevelopment AS lisdbserveraddressdevelopment_111, t0.lisDBServerPortDevelopment AS lisdbserverportdevelopment_112, t0.lisDBAccountUserNameDevelopment AS lisdbaccountusernamedevelopment_113, t0.lisDBAccountPasswordDevelopment AS lisdbaccountpassworddevelopment_114, t0.lisDBNameDevelopment AS lisdbnamedevelopment_115, t0.LISNameDevelopment AS lisnamedevelopment_116, t0.LISVersionDevelopment AS lisversiondevelopment_117, t0.academicYearStart AS academicyearstart_118, t0.academicYearEnd AS academicyearend_119, t0.liveSiteRootUrl AS livesiterooturl_120, t0.enableMetaphone AS enablemetaphone_121, t0.pathMetaphone AS pathmetaphone_122, t0.initialConfigurationCompleted AS initialconfigurationcompleted_123, t0.networkDrivePath AS networkdrivepath_124, t0.permittedFailedLoginAttempt AS permittedfailedloginattempt_125, t0.captchaSiteKey AS captchasitekey_126, t0.captchaSecretKey AS captchasecretkey_127, t0.captchaEnabled AS captchaenabled_128, t0.noticeAttemptingPasswordResetLDAP AS noticeattemptingpasswordresetldap_129, t0.loginInstruction AS logininstruction_130, t0.noticeSignUpNoCwid AS noticesignupnocwid_131, t0.noticeHasLdapAccount AS noticehasldapaccount_132, t0.noticeLdapName AS noticeldapname_133, t0.calllogResources AS calllogresources_134, t0.logoWidth AS logowidth_135, t0.logoHeight AS logoheight_136, t0.connectionChannel AS connectionchannel_137, t0.urlConnectionChannel AS urlconnectionchannel_138, t0.transresProjectSelectionNote AS transresprojectselectionnote_139, t0.transresHumanSubjectName AS transreshumansubjectname_140, t0.transresAnimalSubjectName AS transresanimalsubjectname_141, t0.transresBusinessEntityName AS transresbusinessentityname_142, t0.transresBusinessEntityAbbreviation AS transresbusinessentityabbreviation_143, t0.emailCriticalError AS emailcriticalerror_144, t0.restartServerErrorCounter AS restartservererrorcounter_145, t0.remoteAccessUrl AS remoteaccessurl_146, t0.externalMonitorUrl AS externalmonitorurl_147, t0.monitorScript AS monitorscript_148, t0.monitorCheckInterval AS monitorcheckinterval_149, t0.sendEmailUserAdded AS sendemailuseradded_150, t0.dbBackupConfig AS dbbackupconfig_151, t0.filesBackupConfig AS filesbackupconfig_152, t0.secretKey AS secretkey_153, t0.instanceId AS instanceid_154, t0.showTenantsHomepage AS showtenantshomepage_155, t0.defaultPrimaryPublicUserIdType_id AS defaultprimarypublicuseridtype_id_156, t0.ldapMapperPrimaryPublicUserIdType_id AS ldapmapperprimarypublicuseridtype_id_157, t0.ldapMapperPrimaryPublicUserIdType2_id AS ldapmapperprimarypublicuseridtype2_id_158, t0.autoAssignInstitution_id AS autoassigninstitution_id_159, t0.fellappSiteParameter_id AS fellappsiteparameter_id_160, t0.resappSiteParameter_id AS resappsiteparameter_id_161, t0.calllogSiteParameter_id AS calllogsiteparameter_id_162, t0.crnSiteParameter_id AS crnsiteparameter_id_163, t0.dashboardSiteParameter_id AS dashboardsiteparameter_id_164, t0.navbarFilterInstitution1_id AS navbarfilterinstitution1_id_165, t0.navbarFilterInstitution2_id AS navbarfilterinstitution2_id_166, t0.defaultDeidentifierAccessionType_id AS defaultdeidentifieraccessiontype_id_167, t0.defaultScanAccessionType_id AS defaultscanaccessiontype_id_168, t0.defaultScanMrnType_id AS defaultscanmrntype_id_169, t0.defaultScanDelivery_id AS defaultscandelivery_id_170, t0.defaultOrganizationRecipient_id AS defaultorganizationrecipient_id_171, t0.defaultScanner_id AS defaultscanner_id_172, t0.transresDashboardInstitution_id AS transresdashboardinstitution_id_173, t0.vacreqSiteParameter_id AS vacreqsiteparameter_id_174, t0.telephonySiteParameter_id AS telephonysiteparameter_id_175, t0.authUserGroup_id AS authusergroup_id_176, t0.authServerNetwork_id AS authservernetwork_id_177, t0.authPartnerServer_id AS authpartnerserver_id_178 FROM user_siteparameters t0;

SELECT
  t0.id AS id_1,
  t0.primaryPublicUserId AS primarypublicuserid_2,
  t0.createdby AS createdby_3,
  t0.otherUserParam AS otheruserparam_4,
  t0.testingAccount AS testingaccount_5,
  t0.createDate AS createdate_6,
  t0.failedAttemptCounter AS failedattemptcounter_7,
  t0.lastActivity AS lastactivity_8,
  t0.lastLoggedUrl AS lastloggedurl_9,
  t0.activeAD AS activead_10,
  t0.lastAdCheck AS lastadcheck_11,
  t0.username AS username_12,
  t0.username_canonical AS username_canonical_13,
  t0.enabled AS enabled_14,
  t0.salt AS salt_15,
  t0.password AS password_16,
  t0.last_login AS last_login_17,
  t0.confirmation_token AS confirmation_token_18,
  t0.password_requested_at AS password_requested_at_19,
  t0.roles AS roles_20,
  t0.email AS email_21,
  t0.email_canonical AS email_canonical_22,
  t0.keytype AS keytype_23,
  t0.preferences_id AS preferences_id_24,
  t0.credentials_id AS credentials_id_25,
  t0.avatar_id AS avatar_id_26,
  t27.tooltip AS tooltip_28,
  t27.id AS id_29,
  t27.updateAuthorRoles AS updateauthorroles_30,
  t27.type AS type_31,
  t27.status AS status_32,
  t27.createdate AS createdate_33,
  t27.updatedate AS updatedate_34,
  t27.orderinlist AS orderinlist_35,
  t27.institution_id AS institution_id_36,
  t27.fosuser AS fosuser_37,
  t27.organizationalGroupDefault_id AS organizationalgroupdefault_id_38,
  t27.author AS author_39,
  t27.updateAuthor AS updateauthor_40,
  t0.author_id AS author_id_41
FROM
  user_fosuser t0
  LEFT JOIN scan_perSiteSettings t27 ON t27.fosuser = t0.id
WHERE
  t0.primaryPublicUserId = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.primaryPublicUserId AS primarypublicuserid_2, t0.createdby AS createdby_3, t0.otherUserParam AS otheruserparam_4, t0.testingAccount AS testingaccount_5, t0.createDate AS createdate_6, t0.failedAttemptCounter AS failedattemptcounter_7, t0.lastActivity AS lastactivity_8, t0.lastLoggedUrl AS lastloggedurl_9, t0.activeAD AS activead_10, t0.lastAdCheck AS lastadcheck_11, t0.username AS username_12, t0.username_canonical AS username_canonical_13, t0.enabled AS enabled_14, t0.salt AS salt_15, t0.password AS password_16, t0.last_login AS last_login_17, t0.confirmation_token AS confirmation_token_18, t0.password_requested_at AS password_requested_at_19, t0.roles AS roles_20, t0.email AS email_21, t0.email_canonical AS email_canonical_22, t0.keytype AS keytype_23, t0.preferences_id AS preferences_id_24, t0.credentials_id AS credentials_id_25, t0.avatar_id AS avatar_id_26, t27.tooltip AS tooltip_28, t27.id AS id_29, t27.updateAuthorRoles AS updateauthorroles_30, t27.type AS type_31, t27.status AS status_32, t27.createdate AS createdate_33, t27.updatedate AS updatedate_34, t27.orderinlist AS orderinlist_35, t27.institution_id AS institution_id_36, t27.fosuser AS fosuser_37, t27.organizationalGroupDefault_id AS organizationalgroupdefault_id_38, t27.author AS author_39, t27.updateAuthor AS updateauthor_40, t0.author_id AS author_id_41 FROM user_fosuser t0 LEFT JOIN scan_perSiteSettings t27 ON t27.fosuser = t0.id WHERE t0.primaryPublicUserId = 'system' LIMIT 1;

SELECT
  a.attnum,
  quote_ident(a.attname) AS field,
  t.typname AS type,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  (
    SELECT
      tc.collcollate
    FROM
      pg_catalog.pg_collation tc
    WHERE
      tc.oid = a.attcollation
  ) AS collation,
  (
    SELECT
      t1.typname
    FROM
      pg_catalog.pg_type t1
    WHERE
      t1.oid = t.typbasetype
  ) AS domain_type,
  (
    SELECT
      format_type(t2.typbasetype, t2.typtypmod)
    FROM
      pg_catalog.pg_type t2
    WHERE
      t2.typtype = 'd'
      AND t2.oid = a.atttypid
  ) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  (
    SELECT
      't'
    FROM
      pg_index
    WHERE
      c.oid = pg_index.indrelid
      AND pg_index.indkey[0] = a.attnum
      AND pg_index.indisprimary = 't'
  ) AS pri,
  (
    SELECT
      CASE WHEN a.attgenerated = 's' THEN
        NULL
      ELSE
        pg_get_expr(adbin, adrelid)
      END
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS default,
  (
    SELECT
      pg_description.description
    FROM
      pg_description
    WHERE
      pg_description.objoid = c.oid
      AND a.attnum = pg_description.objsubid
  ) AS comment
FROM
  pg_attribute a
  INNER JOIN pg_class c ON c.oid = a.attrelid
  INNER JOIN pg_type t ON t.oid = a.atttypid
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
  LEFT JOIN pg_depend d ON d.objid = c.oid
  AND d.deptype = 'e'
  AND d.classid = (
    SELECT
      oid
    FROM
      pg_class
    WHERE
      relname = 'pg_class'
  )
WHERE
  a.attnum > 0
  AND c.relkind = 'r'
  AND d.refobjid IS NULL
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
ORDER BY
  a.attnum

SELECT            a.attnum,
            quote_ident(a.attname) AS field,
            t.typname AS type,
            format_type(a.atttypid, a.atttypmod) AS complete_type,
            (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,
            (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,
            (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM
              pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,
            a.attnotnull AS isnotnull,
            (SELECT 't'
             FROM pg_index
             WHERE c.oid = pg_index.indrelid
                AND pg_index.indkey[0] = a.attnum
                AND pg_index.indisprimary = 't'
            ) AS pri,
            (    SELECT
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     FROM pg_attrdef
     WHERE c.oid = pg_attrdef.adrelid
        AND pg_attrdef.adnum=a.attnum) AS default,
            (SELECT pg_description.description
                FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid
            ) AS comment
            FROM pg_attribute a
                INNER JOIN pg_class c
                    ON c.oid = a.attrelid
                INNER JOIN pg_type t
                    ON t.oid = a.atttypid
                INNER JOIN pg_namespace n
                    ON n.oid = c.relnamespace
                LEFT JOIN pg_depend d
                    ON d.objid = c.oid
                        AND d.deptype = 'e'
                        AND d.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class') WHERE a.attnum > 0 AND c.relkind = 'r' AND d.refobjid IS NULL AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') ORDER BY a.attnum;

SELECT
  attnum,
  attname
FROM
  pg_attribute
WHERE
  attrelid = 40972
  AND attnum IN (1)
ORDER BY
  attnum ASC

SELECT attnum, attname FROM pg_attribute WHERE attrelid=40972 AND attnum IN (1) ORDER BY attnum ASC;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  c.relname,
  CASE c.relpersistence
  WHEN 'u' THEN
    true
  ELSE
    false
  END as unlogged,
  obj_description(c.oid, 'pg_class') AS comment
FROM
  pg_class c
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  c.relkind = 'r'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )

SELECT c.relname,
       CASE c.relpersistence WHEN 'u' THEN true ELSE false END as unlogged,
       obj_description(c.oid, 'pg_class') AS comment
FROM pg_class c
     INNER JOIN pg_namespace n
         ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast');

SELECT
  quote_ident(ic.relname) AS relname,
  i.indisunique,
  i.indisprimary,
  i.indkey,
  i.indrelid,
  pg_get_expr(indpred, indrelid) AS "where"
FROM
  pg_index i
  JOIN pg_class AS tc ON tc.oid = i.indrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
  JOIN pg_class AS ic ON ic.oid = i.indexrelid
WHERE
  ic.oid IN (
    SELECT
      indexrelid
    FROM
      pg_index i,
      pg_class c,
      pg_namespace n
    WHERE
      c.oid = i.indrelid
      AND c.relnamespace = n.oid
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )

SELECT                   quote_ident(ic.relname) AS relname,
                   i.indisunique,
                   i.indisprimary,
                   i.indkey,
                   i.indrelid,
                   pg_get_expr(indpred, indrelid) AS "where"
              FROM pg_index i
                   JOIN pg_class AS tc ON tc.oid = i.indrelid
                   JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                   JOIN pg_class AS ic ON ic.oid = i.indexrelid
             WHERE ic.oid IN (
                SELECT indexrelid
                FROM pg_index i, pg_class c, pg_namespace n WHERE c.oid = i.indrelid AND c.relnamespace = n.oid AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast'));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.shortname AS shortname_4,
  t0.description AS description_5,
  t0.type AS type_6,
  t0.createdate AS createdate_7,
  t0.updatedon AS updatedon_8,
  t0.orderinlist AS orderinlist_9,
  t0.updateAuthorRoles AS updateauthorroles_10,
  t0.fulltitle AS fulltitle_11,
  t0.linkToListId AS linktolistid_12,
  t0.entityId AS entityid_13,
  t0.entityNamespace AS entitynamespace_14,
  t0.entityName AS entityname_15,
  t0.version AS version_16,
  t0.textAttribute AS textattribute_17,
  t0.urlSlug AS urlslug_18,
  t0.original_id AS original_id_19,
  t0.creator_id AS creator_id_20,
  t0.updatedby_id AS updatedby_id_21,
  t0.objectType_id AS objecttype_id_22
FROM
  user_usernameType t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.shortname AS shortname_4, t0.description AS description_5, t0.type AS type_6, t0.createdate AS createdate_7, t0.updatedon AS updatedon_8, t0.orderinlist AS orderinlist_9, t0.updateAuthorRoles AS updateauthorroles_10, t0.fulltitle AS fulltitle_11, t0.linkToListId AS linktolistid_12, t0.entityId AS entityid_13, t0.entityNamespace AS entitynamespace_14, t0.entityName AS entityname_15, t0.version AS version_16, t0.textAttribute AS textattribute_17, t0.urlSlug AS urlslug_18, t0.original_id AS original_id_19, t0.creator_id AS creator_id_20, t0.updatedby_id AS updatedby_id_21, t0.objectType_id AS objecttype_id_22 FROM user_usernameType t0 WHERE t0.id = 4;

SELECT
  t0.suffix AS suffix_1,
  t0.firstName AS firstname_2,
  t0.middleName AS middlename_3,
  t0.lastName AS lastname_4,
  t0.displayName AS displayname_5,
  t0.preferredPhone AS preferredphone_6,
  t0.preferredMobilePhone AS preferredmobilephone_7,
  t0.mobilePhoneVerifyCode AS mobilephoneverifycode_8,
  t0.mobilePhoneVerifyCodeDate AS mobilephoneverifycodedate_9,
  t0.preferredMobilePhoneVerified AS preferredmobilephoneverified_10,
  t0.email AS email_11,
  t0.emailCanonical AS emailcanonical_12,
  t0.initials AS initials_13,
  t0.salutation AS salutation_14,
  t0.id AS id_15,
  t0.updateAuthorRoles AS updateauthorroles_16,
  t0.type AS type_17,
  t0.status AS status_18,
  t0.createdate AS createdate_19,
  t0.updatedate AS updatedate_20,
  t0.orderinlist AS orderinlist_21,
  t0.user_id AS user_id_22,
  t0.author AS author_23,
  t0.updateAuthor AS updateauthor_24
FROM
  user_userInfo t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.displayName ASC

SELECT t0.suffix AS suffix_1, t0.firstName AS firstname_2, t0.middleName AS middlename_3, t0.lastName AS lastname_4, t0.displayName AS displayname_5, t0.preferredPhone AS preferredphone_6, t0.preferredMobilePhone AS preferredmobilephone_7, t0.mobilePhoneVerifyCode AS mobilephoneverifycode_8, t0.mobilePhoneVerifyCodeDate AS mobilephoneverifycodedate_9, t0.preferredMobilePhoneVerified AS preferredmobilephoneverified_10, t0.email AS email_11, t0.emailCanonical AS emailcanonical_12, t0.initials AS initials_13, t0.salutation AS salutation_14, t0.id AS id_15, t0.updateAuthorRoles AS updateauthorroles_16, t0.type AS type_17, t0.status AS status_18, t0.createdate AS createdate_19, t0.updatedate AS updatedate_20, t0.orderinlist AS orderinlist_21, t0.user_id AS user_id_22, t0.author AS author_23, t0.updateAuthor AS updateauthor_24 FROM user_userInfo t0 WHERE t0.user_id = 1 ORDER BY t0.displayName ASC;

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SHOW search_path

SHOW search_path;