How to import sql file in postgresql using command line?
Syntex: psql -h localhost -U postgres -p PORT DATABASE < FILE_PATH Command: psql -h localhost -U postgres -p 5432 testdb
Read More
Postgres
How to create stored procedure in postgresql?
1) Create Procedure CREATE OR REPLACE PROCEDURE pgProcedure () as $$ BEGIN SELECT LastName from persons; END; $$ LANGUAGE plpgsql;
Read More
How to Connect PostgreSQL with Laravel using Docker
Create Docker-composer.yml in root version: “3.7” networks: app-network: driver: bridge services: app:
Read More
How to Create a Function in Postgresql Using Pgadmin 4?
create or replace function myFunction(x TIMESTAMP, y TIMESTAMP) returns TIMESTAMP language plpgsql as $$ declare fechatimestamp TIMESTAMP; begin fechatimestamp:=null; fechatimestamp:=
Read More