Maintenance of the complete path of the current directory to the variable



  • How in postgresql in sql-cript keep the full path of the current director to the variable or the table?
    I know how to put it on the screen!



  • I was able to figure it out. Code

    DROP TABLE tbl_pwd;
    CREATE TABLE tbl_pwd(
        pwd TEXT
    );
    

    \COPY tbl_pwd FROM PROGRAM 'pwd';
    SELECT * FROM tbl_pwd;


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2