{"Entry":{"collection":"conn","key":"tty","name":"tty","aliases":["PGTTY","tty"],"metadata":{"aliases":["PGTTY","tty"],"category":"Session and protocol","content_hash":"43d277f1ed68ce7742e4a5616f77088b4a0d245b9f686e0873cbd85dc9831ddc","imported_at":"2026-09-30T00:40:35.216665+08:00","name":"tty","name_zh":"","slug":"tty","summary":"Ignored (formerly, this specified where to send server debug output)."}},"Definition":{"Collection":"conn","Key":"tty","SourceDatabase":"center","Version":"13","SourceTable":"connection_parameter","SourceKey":"tty","SourceRevision":"614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6","Facts":{"comparison_data":{"compiled_default_expression":"DefaultTty","default_evidence":[],"definition":"Ignored (formerly, this specified where to send server debug output).","documented":true,"environment":"PGTTY","keyword":"tty"},"comparison_hash":"64a0b183ec175592478f5961560dc96e395aadca4c83689cb4fba4a69486aa76","default_evidence":[],"description":["Ignored (formerly, this specified where to send server debug output)."],"documented":true,"environment":[],"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"}],"keyword":"tty","manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"LIBPQ-CONNECT-TTY\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etty\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eIgnored (formerly, this specified where to send server debug output).\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"libpq-connect.html#LIBPQ-CONNECT-TTY","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."],"related":[{"label":"Connection service file","url":"/docs/13/libpq-pgservice.html"},{"label":"Password file","url":"/docs/13/libpq-pgpass.html"},{"label":"All libpq environment variables","url":"/docs/13/libpq-envars.html"}],"release":{"channel":"historical","evidence_kind":"English manual and source declarations","label":"13.23","major":"13","manifest":{"index":"index.html","major":"13","pages":1139,"pdf":{"A4":{"built_at":"2026-09-26","bytes":13843239,"pages":2826,"sha256":"171cc09f90936dbc1cbd503a98ff07ae72ea58ab9771ff051313f1217737799c","url":"/files/documentation/pdf/13/postgresql-13-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":13739572,"pages":2984,"sha256":"48d09c6e197d9db4220f41afe83efe848a8661b1b168d3b89419751ecaf6c24d","url":"/files/documentation/pdf/13/postgresql-13-US.pdf"}},"release":"13.23","source_mode":"en HTML verified against the pinned official archive","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","svg_assets":3,"tree":"13"},"ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"sections":[{"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":"Default resolution and service-file precedence"},{"paragraphs":[],"title":"Environment variable evidence"},{"paragraphs":["\"tty\" is no longer used either, but keep it present for backwards compatibility."],"title":"Source declaration notes"}],"signature":"tty","source_option":{"compiled_default_expression":"DefaultTty","declaration":"\"tty\", \"PGTTY\", DefaultTty, NULL, \"Backend-Debug-TTY\", \"D\", 40, offsetof(struct pg_conn, pgtty)","environment":"PGTTY","keyword":"tty","source_notes":["\"tty\" is no longer used either, but keep it present for backwards compatibility."]},"sources":[{"anchor":"LIBPQ-CONNECT-TTY","file":"libpq-connect.html","label":"13.23 English manual · libpq-connect.html","sha256":"2e9c70e9aed0c3850c1af1c7680be465582020bb8c2dfcb009fb9ffe3cd194b6","url":"/docs/13/libpq-connect.html#LIBPQ-CONNECT-TTY"},{"archive_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","file":"src/interfaces/libpq/fe-connect.c","label":"13.23 libpq connection option declarations","sha256":"406a116bf54e8afc41f76cf0ad669713e981140c9940b54afad98e7393467e9d","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"anchor":"","file":"libpq-envars.html","label":"13.23 English manual · libpq-envars.html","sha256":"1125e5a919204ff2f54691c1558a08efd818f206f6175cadba3cf6cbc17679bb","url":"/docs/13/libpq-envars.html"},{"anchor":"","file":"libpq-pgservice.html","label":"13.23 English manual · libpq-pgservice.html","sha256":"d31c36b3039250e7d190706f7b777328c01980795deb0440063c4bfcef125794","url":"/docs/13/libpq-pgservice.html"}],"tables":[]},"ManualEvidence":{"manual_path":"libpq-connect.html#LIBPQ-CONNECT-TTY","release":{"channel":"historical","evidence_kind":"English manual and source declarations","label":"13.23","major":"13","manifest":{"index":"index.html","major":"13","pages":1139,"pdf":{"A4":{"built_at":"2026-09-26","bytes":13843239,"pages":2826,"sha256":"171cc09f90936dbc1cbd503a98ff07ae72ea58ab9771ff051313f1217737799c","url":"/files/documentation/pdf/13/postgresql-13-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":13739572,"pages":2984,"sha256":"48d09c6e197d9db4220f41afe83efe848a8661b1b168d3b89419751ecaf6c24d","url":"/files/documentation/pdf/13/postgresql-13-US.pdf"}},"release":"13.23","source_mode":"en HTML verified against the pinned official archive","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","source_url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","svg_assets":3,"tree":"13"},"ref":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2","revision":"614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6","source_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"},"sources":[{"anchor":"LIBPQ-CONNECT-TTY","file":"libpq-connect.html","label":"13.23 English manual · libpq-connect.html","sha256":"2e9c70e9aed0c3850c1af1c7680be465582020bb8c2dfcb009fb9ffe3cd194b6","url":"/docs/13/libpq-connect.html#LIBPQ-CONNECT-TTY"},{"archive_sha256":"6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6","file":"src/interfaces/libpq/fe-connect.c","label":"13.23 libpq connection option declarations","sha256":"406a116bf54e8afc41f76cf0ad669713e981140c9940b54afad98e7393467e9d","url":"https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2"},{"anchor":"","file":"libpq-envars.html","label":"13.23 English manual · libpq-envars.html","sha256":"1125e5a919204ff2f54691c1558a08efd818f206f6175cadba3cf6cbc17679bb","url":"/docs/13/libpq-envars.html"},{"anchor":"","file":"libpq-pgservice.html","label":"13.23 English manual · libpq-pgservice.html","sha256":"d31c36b3039250e7d190706f7b777328c01980795deb0440063c4bfcef125794","url":"/docs/13/libpq-pgservice.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"conn","Key":"tty","SourceDatabase":"center","Version":"13","Locale":"en","Title":"tty","Summary":"Ignored (formerly, this specified where to send server debug output).","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"LIBPQ-CONNECT-TTY\"\u003e\u003cspan\u003e\u003ccode\u003etty\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eIgnored (formerly, this specified where to send server debug output).\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6","ContentHash":"51481d309a706e96daedd669d8582e33484c5dd1ecbcb63d359e3b9c82d153dc","Payload":{"description":["Ignored (formerly, this specified where to send server debug output)."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"LIBPQ-CONNECT-TTY\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003etty\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\n\u003cp\u003eIgnored (formerly, this specified where to send server debug output).\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"Connection service file","url":"/docs/13/libpq-pgservice.html"},{"label":"Password file","url":"/docs/13/libpq-pgpass.html"},{"label":"All libpq environment variables","url":"/docs/13/libpq-envars.html"}],"sections":[{"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":"Default resolution and service-file precedence"},{"paragraphs":[],"title":"Environment variable evidence"},{"paragraphs":["\"tty\" is no longer used either, but keep it present for backwards compatibility."],"title":"Source declaration notes"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}