postgres=# \s
\d
\l
\l
\c
\c postgres
select pg_backend_pid();
alter user postgres password 'abcd12345';
\c demo
\c
\l
\c
\l
select * from pg_database;
show data_directory
show data_directory;
show data_directory;
select setting from pg_settings;
select * from pg_settings;
show data_directory;
\q
\conninfo
SELECT *
FROM pg_settings
WHERE name = 'port';
\c
\!
\! ls -lrt
\s
\d
\l
\s
postgres=#
No comments:
Post a Comment