create table without using psql

[pcouas]

Hello

Can i create an postgres table without using psql
Currentl i have two step ?
echo =========================
echo STEP 1a - EXPORT TABLE CONFIG
rem call ora2pg -c %CONFIG% -t TABLE -o tables.sql -s scgp_refonte2026
call ora2pg -c %CONFIG% -t TABLE -o %FILE%
IF %ERRORLEVEL% NEQ 0 (
echo ERROR during TABLE export
exit /b 1
)

echo STEP 1b - PHYSICALLY CREATE TABLE
call C:\postgresql-18\bin\psql -h %PGHOST% -p %PGPORT% -d %PGDBNAME% -f %FILE%

Can i have same result in one single command ?
Regards

[darold]

I don't know on Windows but on linux I would have write it like this:

ora2pg -c $CONFIG -t TABLE -o $FILE && psql -h $PGHOST -p $PGPORT -d $PGDBNAME -f $FILE

[pcouas]

ok so, could not avoid to call psql
ora2pg can not alone create table in postgres

[darold]

No, only data migration can be done directly, this is voluntary to allow/force you to review the schema before importing.