Обсуждение: BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.
От
anup.saund@gmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM3NApMb2dnZWQgYnk6ICAg ICAgICAgIEFudXAgU2F1bmQKRW1haWwgYWRkcmVzczogICAgICBhbnVwLnNh dW5kQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNi4wCk9wZXJh dGluZyBzeXN0ZW06ICAgV2luZG93cyA3ICg2NGJpdCkKRGVzY3JpcHRpb246 ICAgICAgICAKClNDUkVFTlNIT1QgT0YgT1VUUFVUDQo9PT09PT09PT09PT09 PT09PT09PQ0KaHR0cHM6Ly9kbC5kcm9wYm94dXNlcmNvbnRlbnQuY29tL3Uv MzEyMjk2L291dHB1dC5QTkcNCg0KVGVzdCBTY2VuYXJpbw0KPT09PT09PT09 PT09PQ0KUG9zdGdyZVNRTCAtIDkuNCB3YXMgYWxyZWFkeSBpbnN0YWxsZWQu DQpSdW5uaW5nIHRoZSBmb2xsb3dpbmcgY29tbWFuZCB3b3VsZCBwcm9kdWNl IGFuIG91dHB1dCBhcyBwZXIgdGhlIHNjcmVlbnNob3QKYWJvdmUuDQoNCkNE IGM6XFByb2dyYW0gRmlsZXNcUG9zdGdyZVNRTA0KDQouXDkuNFxiaW5ccHNx bC5leGUgIC1sdFUgcG9zdGdyZXMgLXAgNTQzMyAtaCBsb2NhbGhvc3QgLWQg ZGVsbHN0b3JlMiAtYyAKIlxkdHZzIiINCg0KDQpJc3N1ZQ0KPT09PT0NCg0K UnVubmluZyB0aGUgc2FtZSBjb21tYW5kIGFmdGVyIGluc3RhbGxpbmcgOS42 LjAgd291bGQgZ2l2ZSBhIGxpc3QgYQpkYXRhYmFzZXMsIG5vdCB0YWJsZXMv dmlld3Mvc2VxdWVuY2VzLg0KDQouXDkuNlxiaW5ccHNxbC5leGUgIC1sdFUg cG9zdGdyZXMgLXAgNTQzMyAtaCBsb2NhbGhvc3QgLWQgZGVsbHN0b3JlMiAt YyAKIlxkdHZzIiINCg0KDQpBbHNvIHRlc3RlZCB3aXRoIFBvc3RncmVTUUwg dmVyc2lvbiA5LjUgLSB0aGF0IHZlcnNpb24gZG9lcyBwcm9kdWNlIHRoZSBz YW1lCm91dHB1dCBhcyA5LjQuDQoNClVuZm9ydHVuYXRlbHksIEkgY2Fubm90 IGdldCB0aGUgY29tbWFuZHMgdG8gd29yayB3aXRoIDkuNi4NCg0KSSBoYXZl IHJlYWQgb3ZlciB0aGUgZG9jdW1lbnRhdGlvbiBidXQgdGhhdCBzcGVjaWZp YyBzZWN0aW9uIGlzIHN1Z2dlc3RpbmcKdGhlIHNhbWUgdXNhZ2UgYXMgOS41 LzkuNC4NCg0KQW55IGhlbHAgd291bGQgYmUgZ3JlYXRseSBhcHByZWNpYXRl ZC4KCg==
anup.saund@gmail.com writes: > Running the same command after installing 9.6.0 would give a list a > databases, not tables/views/sequences. > .\9.6\bin\psql.exe -ltU postgres -p 5433 -h localhost -d dellstore2 -c > "\dtvs"" I don't think this is a bug. -l is documented as "list available databases, then exit". It's not specified whether that takes preference over -c or not. The changes in 9.6 to make -c act more like -f evidently caused it to not take precedence over -l anymore, and that seems fine from here. regards, tom lane