Django execute sql raw

Asked Nov 16 '21 at 17:13

Active Nov 16 '21 at 17:13

Viewed 119 times

I want to print the result by running a mssql query on any page in my postgresql project, how can I do it?

for exam.

SELECT  TOP(11) * FROM dbo.UserObject WITH (NOLOCK) WHERE u_logon_name='cc@gmail.com'

My default db setting is postgresql but I want to run mssql query;

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'postgres',
        'ALIAS': 'XX',
        'USER': 'XX',
        'PASSWORD': 'XX',
        'HOST': 'XX',
        'PORT': 'XX',
    }
}

asked Nov 16 '21 at 17:13

tcblue

So you are asking how to use MS SQL Server instead of Postgres for your project? What do you mean by "...running a mssql query .. in my postgresql project..."? – squillman Nov 16 '21 at 17:27
@squillman I use postgresql db by default in my project, but I want to run sql query in my views and print the result – tcblue Nov 16 '21 at 17:34
So you are saying you want to use 2 different database platforms then? – squillman Nov 16 '21 at 17:44
Yes that's right – tcblue Nov 16 '21 at 17:48

Django execute sql raw

0 Answers0