CSV Import through PGAdmin Not working, alternate options?

Hello,

Indeed, uploading a file directly to a managed database is quite likely not going to work with the default permissions.

What I could suggest is to use a script to do the import. For example, you could use the following Python script to do the import:

import pandas as pd

df = pd.read_csv('/path/to/your.csv')
df.columns = [c.lower() for c in df.columns] # PostgreSQL doesn't like capitals or spaces

from sqlalchemy import create_engine
engine = create_engine('postgresql://username:password@localhost:5432/dbname')

df.to_sql("my_table_name", engine)

Make sure to change the connection string and the table name.

Best,

Bobby