{"kind": "conn", "major": "18", "item": {"slug": "tty", "name": "tty", "name_zh": "", "category": "Session and protocol", "summary": "Not recorded in the selected version.", "aliases": ["PGTTY", "tty"], "content_hash": "43d277f1ed68ce7742e4a5616f77088b4a0d245b9f686e0873cbd85dc9831ddc", "versions": {"10": {"facts": [{"label": "Client library", "value": "libpq 10.23"}, {"label": "Manual definition", "value": "Documented"}, {"label": "Source environment fallback", "value": "PGTTY"}, {"label": "Compiled fallback expression", "value": "DefaultTty"}], "tables": [], "keyword": "tty", "related": [{"url": "/docs/10/libpq-pgservice.html", "label": "Connection service file"}, {"url": "/docs/10/libpq-pgpass.html", "label": "Password file"}, {"url": "/docs/10/libpq-envars.html", "label": "All libpq environment variables"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/10/postgresql-10-A4.pdf", "bytes": 12631706, "pages": 2591, "sha256": "34497ab9efb45c5bdf1bd11b9016b5451354feb462fa029cf74557a5fa5fbbc1", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/10/postgresql-10-US.pdf", "bytes": 12531684, "pages": 2724, "sha256": "429cc7133ddf4f97c560aa466dc9caea4b718721a8321e293357037cf0af4733", "built_at": "2026-09-26"}}, "tree": "10", "index": "index.html", "major": "10", "pages": 1085, "release": "10.23", "source_url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "revision": "f9301feba91e2e2566038a36b8cee0e4402db68989538f88670fddd20b1f78ea", "evidence_kind": "English manual and source declarations", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "sources": [{"url": "/docs/10/libpq-connect.html#LIBPQ-CONNECT-TTY", "file": "libpq-connect.html", "label": "10.23 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-TTY", "sha256": "153ad57ac835922140534bebdbfc61776676beddc59f85c240e039721e514699"}, {"url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "10.23 libpq connection option declarations", "sha256": "de8b800e515b3bf4dfe66cafcdfbb34133ec7c5848f255eabb2a1d4c0855d214", "archive_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, {"url": "/docs/10/libpq-envars.html", "file": "libpq-envars.html", "label": "10.23 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "241a428dcfcac6131f39c8d9f1f178fa15a8ebe331381fe738f1ceb12ca22c54"}, {"url": "/docs/10/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "10.23 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "9b317c875bed047e3baba0da1777c71257c0d4a636392624f4e4f3c3337b0912"}], "sections": [{"title": "Default resolution and service-file precedence", "paragraphs": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, {"title": "Environment variable evidence", "paragraphs": []}, {"title": "Source declaration notes", "paragraphs": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."]}], "signature": "tty", "documented": true, "description": ["Ignored (formerly, this specified where to send server debug output)."], "environment": [], "manual_html": "
tty
\n

Ignored (formerly, this specified where to send server debug output).

\n
", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-TTY", "source_option": {"keyword": "tty", "declaration": "\"tty\", \"PGTTY\", DefaultTty, NULL, \"Backend-Debug-TTY\", \"D\", 40, offsetof(struct pg_conn, pgtty)", "environment": "PGTTY", "source_notes": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."], "compiled_default_expression": "DefaultTty"}, "comparison_data": {"keyword": "tty", "definition": "Ignored (formerly, this specified where to send server debug output).", "documented": true, "environment": "PGTTY", "default_evidence": [], "compiled_default_expression": "DefaultTty"}, "comparison_hash": "64a0b183ec175592478f5961560dc96e395aadca4c83689cb4fba4a69486aa76", "default_evidence": [], "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, "11": {"facts": [{"label": "Client library", "value": "libpq 11.22"}, {"label": "Manual definition", "value": "Documented"}, {"label": "Source environment fallback", "value": "PGTTY"}, {"label": "Compiled fallback expression", "value": "DefaultTty"}], "tables": [], "keyword": "tty", "related": [{"url": "/docs/11/libpq-pgservice.html", "label": "Connection service file"}, {"url": "/docs/11/libpq-pgpass.html", "label": "Password file"}, {"url": "/docs/11/libpq-envars.html", "label": "All libpq environment variables"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/11/postgresql-11-A4.pdf", "bytes": 13057499, "pages": 2732, "sha256": "41d75855e610d0d9b8802b87dc5b080bef8d7e91c7cf69401fbf8d3cf801b4b5", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/11/postgresql-11-US.pdf", "bytes": 12961189, "pages": 2883, "sha256": "6a8899ef36935a5b7ed2b436207564a567a4ef1eb1c2200195876b8de4d4fa30", "built_at": "2026-09-26"}}, "tree": "11", "index": "index.html", "major": "11", "pages": 1125, "release": "11.22", "source_url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "revision": "53315ddaf3b3f9e6669fd1edc096bbb2cd4a65ea3e836c89e542b43af9ba3a7f", "evidence_kind": "English manual and source declarations", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "sources": [{"url": "/docs/11/libpq-connect.html#LIBPQ-CONNECT-TTY", "file": "libpq-connect.html", "label": "11.22 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-TTY", "sha256": "51609c4e32eec49656c45de2c14a8ad69e10c9b3300bc9c57658857fcee1d824"}, {"url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "11.22 libpq connection option declarations", "sha256": "89673096491d2ff370af0e614e035336cba52c14107a4ea22bb0ed234fa1c684", "archive_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, {"url": "/docs/11/libpq-envars.html", "file": "libpq-envars.html", "label": "11.22 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "0012607dbb5e04e9ed34fd34a0eb8de14f0a6f5cb07fe95ca868fb2fddf426b5"}, {"url": "/docs/11/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "11.22 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "c0f63b0b0757a3ca6f35c8f6617ee3850d5536c11fabc4fa747ad18467a26f6f"}], "sections": [{"title": "Default resolution and service-file precedence", "paragraphs": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, {"title": "Environment variable evidence", "paragraphs": []}, {"title": "Source declaration notes", "paragraphs": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."]}], "signature": "tty", "documented": true, "description": ["Ignored (formerly, this specified where to send server debug output)."], "environment": [], "manual_html": "
tty
\n

Ignored (formerly, this specified where to send server debug output).

\n
", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-TTY", "source_option": {"keyword": "tty", "declaration": "\"tty\", \"PGTTY\", DefaultTty, NULL, \"Backend-Debug-TTY\", \"D\", 40, offsetof(struct pg_conn, pgtty)", "environment": "PGTTY", "source_notes": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."], "compiled_default_expression": "DefaultTty"}, "comparison_data": {"keyword": "tty", "definition": "Ignored (formerly, this specified where to send server debug output).", "documented": true, "environment": "PGTTY", "default_evidence": [], "compiled_default_expression": "DefaultTty"}, "comparison_hash": "64a0b183ec175592478f5961560dc96e395aadca4c83689cb4fba4a69486aa76", "default_evidence": [], "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, "12": {"facts": [{"label": "Client library", "value": "libpq 12.22"}, {"label": "Manual definition", "value": "Documented"}, {"label": "Source environment fallback", "value": "PGTTY"}, {"label": "Compiled fallback expression", "value": "DefaultTty"}], "tables": [], "keyword": "tty", "related": [{"url": "/docs/12/libpq-pgservice.html", "label": "Connection service file"}, {"url": "/docs/12/libpq-pgpass.html", "label": "Password file"}, {"url": "/docs/12/libpq-envars.html", "label": "All libpq environment variables"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/12/postgresql-12-A4.pdf", "bytes": 13424351, "pages": 2803, "sha256": "7422cf53fd1939e7a3d2925231a88b0330e468afa5393627cac0ff86158a0621", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/12/postgresql-12-US.pdf", "bytes": 13322565, "pages": 2958, "sha256": "51f3b04e72907fc38512685946223452ea65f84419c60c66241dfa3396035e77", "built_at": "2026-09-26"}}, "tree": "12", "index": "index.html", "major": "12", "pages": 1131, "release": "12.22", "source_url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "svg_assets": 2, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "revision": "7a827e97cbfacd7febff75f34443e2043e40723de5b6d8c9d81a9430b65a37e4", "evidence_kind": "English manual and source declarations", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "/docs/12/libpq-connect.html#LIBPQ-CONNECT-TTY", "file": "libpq-connect.html", "label": "12.22 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-TTY", "sha256": "600a43dc93518d62d1c83c8b09d4b695bf1a04e4a5a58b239dc9aa287e83f3d2"}, {"url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "12.22 libpq connection option declarations", "sha256": "c7b1ad8e03dd5655cabab7572b0a3dc3c9d0f8f1646a5d03a92cd4edbb1d021b", "archive_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, {"url": "/docs/12/libpq-envars.html", "file": "libpq-envars.html", "label": "12.22 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "e4c92c7bbed845b27426c607f96d549f30096a977454ed19608451a26bfb93cb"}, {"url": "/docs/12/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "12.22 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "dc1adeb371e8a783b184c80e9708982e1e44a9da311604009643b12cb41a600c"}], "sections": [{"title": "Default resolution and service-file precedence", "paragraphs": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, {"title": "Environment variable evidence", "paragraphs": []}, {"title": "Source declaration notes", "paragraphs": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."]}], "signature": "tty", "documented": true, "description": ["Ignored (formerly, this specified where to send server debug output)."], "environment": [], "manual_html": "
tty
\n

Ignored (formerly, this specified where to send server debug output).

\n
", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-TTY", "source_option": {"keyword": "tty", "declaration": "\"tty\", \"PGTTY\", DefaultTty, NULL, \"Backend-Debug-TTY\", \"D\", 40, offsetof(struct pg_conn, pgtty)", "environment": "PGTTY", "source_notes": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."], "compiled_default_expression": "DefaultTty"}, "comparison_data": {"keyword": "tty", "definition": "Ignored (formerly, this specified where to send server debug output).", "documented": true, "environment": "PGTTY", "default_evidence": [], "compiled_default_expression": "DefaultTty"}, "comparison_hash": "64a0b183ec175592478f5961560dc96e395aadca4c83689cb4fba4a69486aa76", "default_evidence": [], "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, "13": {"facts": [{"label": "Client library", "value": "libpq 13.23"}, {"label": "Manual definition", "value": "Documented"}, {"label": "Source environment fallback", "value": "PGTTY"}, {"label": "Compiled fallback expression", "value": "DefaultTty"}], "tables": [], "keyword": "tty", "related": [{"url": "/docs/13/libpq-pgservice.html", "label": "Connection service file"}, {"url": "/docs/13/libpq-pgpass.html", "label": "Password file"}, {"url": "/docs/13/libpq-envars.html", "label": "All libpq environment variables"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/13/postgresql-13-A4.pdf", "bytes": 13843239, "pages": 2826, "sha256": "171cc09f90936dbc1cbd503a98ff07ae72ea58ab9771ff051313f1217737799c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/13/postgresql-13-US.pdf", "bytes": 13739572, "pages": 2984, "sha256": "48d09c6e197d9db4220f41afe83efe848a8661b1b168d3b89419751ecaf6c24d", "built_at": "2026-09-26"}}, "tree": "13", "index": "index.html", "major": "13", "pages": 1139, "release": "13.23", "source_url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "revision": "614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6", "evidence_kind": "English manual and source declarations", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "/docs/13/libpq-connect.html#LIBPQ-CONNECT-TTY", "file": "libpq-connect.html", "label": "13.23 English manual \u00b7 libpq-connect.html", "anchor": "LIBPQ-CONNECT-TTY", "sha256": "2e9c70e9aed0c3850c1af1c7680be465582020bb8c2dfcb009fb9ffe3cd194b6"}, {"url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "file": "src/interfaces/libpq/fe-connect.c", "label": "13.23 libpq connection option declarations", "sha256": "406a116bf54e8afc41f76cf0ad669713e981140c9940b54afad98e7393467e9d", "archive_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, {"url": "/docs/13/libpq-envars.html", "file": "libpq-envars.html", "label": "13.23 English manual \u00b7 libpq-envars.html", "anchor": "", "sha256": "1125e5a919204ff2f54691c1558a08efd818f206f6175cadba3cf6cbc17679bb"}, {"url": "/docs/13/libpq-pgservice.html", "file": "libpq-pgservice.html", "label": "13.23 English manual \u00b7 libpq-pgservice.html", "anchor": "", "sha256": "d31c36b3039250e7d190706f7b777328c01980795deb0440063c4bfcef125794"}], "sections": [{"title": "Default resolution and service-file precedence", "paragraphs": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}, {"title": "Environment variable evidence", "paragraphs": []}, {"title": "Source declaration notes", "paragraphs": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."]}], "signature": "tty", "documented": true, "description": ["Ignored (formerly, this specified where to send server debug output)."], "environment": [], "manual_html": "
tty
\n

Ignored (formerly, this specified where to send server debug output).

\n
", "manual_path": "libpq-connect.html#LIBPQ-CONNECT-TTY", "source_option": {"keyword": "tty", "declaration": "\"tty\", \"PGTTY\", DefaultTty, NULL, \"Backend-Debug-TTY\", \"D\", 40, offsetof(struct pg_conn, pgtty)", "environment": "PGTTY", "source_notes": ["\"tty\" is no longer used either, but keep it present for backwards compatibility."], "compiled_default_expression": "DefaultTty"}, "comparison_data": {"keyword": "tty", "definition": "Ignored (formerly, this specified where to send server debug output).", "documented": true, "environment": "PGTTY", "default_evidence": [], "compiled_default_expression": "DefaultTty"}, "comparison_hash": "64a0b183ec175592478f5961560dc96e395aadca4c83689cb4fba4a69486aa76", "default_evidence": [], "precedence_evidence": ["The following environment variables can be used to select default connection parameter values, which will be used by PQconnectdb , PQsetdbLogin and PQsetdb if no value is directly specified by the calling code. These are useful to avoid hard-coding database connection information into simple client applications, for example.", "Service names can be defined in either a per-user service file or a system-wide file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named ~/.pg_service.conf . On Microsoft Windows, it is named %APPDATA%\\postgresql\\.pg_service.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable PGSERVICEFILE . The system-wide file is named pg_service.conf . By default it is sought in the etc directory of the PostgreSQL installation (use pg_config --sysconfdir to identify this directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable PGSYSCONFDIR .", "Connection parameters obtained from a service file are combined with parameters obtained from other sources. A service file setting overrides the corresponding environment variable, and in turn can be overridden by a value given directly in the connection string. For example, using the above service file, a connection string service=mydb port=5434 will use host somehost , port 5434 , user admin , and other parameters as set by environment variables or built-in defaults."]}}}, "snapshot": null, "comparison": {"left": "13", "right": "14", "status": "removed", "diff": "--- PostgreSQL 13\n+++ PostgreSQL 14\n@@ -1,8 +1 @@\n-{\n- \"compiled_default_expression\": \"DefaultTty\",\n- \"default_evidence\": [],\n- \"definition\": \"Ignored (formerly, this specified where to send server debug output).\",\n- \"documented\": true,\n- \"environment\": \"PGTTY\",\n- \"keyword\": \"tty\"\n-}\n+Not recorded in this version"}}