saving queries using SQL Shell (psql)

jamielynethorpe / ETL-project

Extract, Transform and Load Databases

8 stars 7 forks source link

saving queries using SQL Shell (psql) #2

Open Harry-KIT opened 2 years ago

Harry-KIT commented 2 years ago

Hi good job. I am facing a problem. How can i save my queries by using SQL Shell. It is clear if I use pyadmin to do that. But i forgot my password. So in this case, Can I use SQL shell. I searched it on google, but couldn't find anything valuable

Harry-KIT commented 2 years ago

psql -h localhost -U postgres -d gun_violance \o C:/Projects/etldev/etl-project1/Gun_Violence_TableSchema.sql

i wrote the command above, but Gun_Violence_TableSchema.sql is empty.