Convert SQL Server to PostgreSQL
A free online converter that translates SQL Server queries into PostgreSQL. Paste your SQL, press Translate, and Query Studio rewrites the syntax that differs between the two databases — instantly, with no login and nothing stored.
SQL Server → PostgreSQL example
Here is a real SQL Server query and the PostgreSQL output Query Studio produces:
SELECT TOP 10 u.id, u.name, COUNT(o.id) AS orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.created_at > '2024-01-01' AND u.active = 1
GROUP BY u.id, u.name
HAVING COUNT(o.id) > 3
ORDER BY orders DESC;SELECT
u.id,
u.name,
COUNT(o.id) AS orders
FROM
users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE
u.created_at > '2024-01-01'
AND u.active = 1
GROUP BY
u.id,
u.name
HAVING
COUNT(o.id) > 3
ORDER BY
orders DESC
LIMIT
10What changes from SQL Server to PostgreSQL
- Identifier quoting is rewritten from bracketed [identifiers] to double-quoted "identifiers".
- Row limiting is converted from SQL Server's TOP n to PostgreSQL's LIMIT n, including any OFFSET for pagination.
- Null-handling functions such as ISNULL() are mapped to COALESCE().
- Current-timestamp functions like GETDATE() become NOW() / CURRENT_TIMESTAMP.
- The result is re-indented and keyword-cased in PostgreSQL style so it's ready to paste and run.
How to convert SQL Server to PostgreSQL
- Open the Query Studio editor and choose SQL Server as the “From” dialect.
- Choose PostgreSQL as the “To” dialect.
- Paste your SQL Server query and press Translate — copy the PostgreSQL result.
Try it with your own query
The editor is preloaded with SQL Server → PostgreSQL. You can also explain, format, validate and analyze the result.
Convert SQL Server to PostgreSQL now →SQL Server to PostgreSQL FAQ
Is this SQL Server to PostgreSQL converter free?
Yes — it's completely free with no account, no sign-up and no usage limits. Your query is processed to return the result and never stored.
Is the SQL Server to PostgreSQL conversion accurate?
Query Studio rewrites syntax deterministically using real SQL parsers, so it gives the same result every time. It handles the common differences automatically; always review complex, vendor-specific queries before running them in production.
Can I convert PostgreSQL back to SQL Server?
Yes. Use the PostgreSQL to SQL Server converter, or press the Swap (⇄) button inside the editor to flip the direction instantly.